asked on

SQL server agent job not running

I am using SQL server 2005 and i have set up an SQL server agent job to run a stored procedure every 30 minutes but for some reason the job is failing to run.

If i simply call teh stored procedure it works fine and i have no idea why the job isn;t working.

Any advice would be greatfully received.

Guy Hengel [angelIII / a3]

what is the stored proc doing?

jodman

ASKER

Originally is was selecting records from one table into a new table dependant on some column values.

However i changed the code to simply drop 2 tables to keep the code simple in order to test whether my more complex code was causing the job not to run.

This would appear to not be the case as the job / SP continue to not run.

Guy Hengel [angelIII / a3]

does the table query remote servers?

jodman

ASKER

No, the code simply drops 2 tables from the server.

SOLUTION

Guy Hengel [angelIII / a3]

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

jodman

ASKER

The job has never run and so there are no entires in the job history.

SOLUTION

ptjcb

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

SOLUTION

sanjeev559

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

ASKER CERTIFIED SOLUTION

timeshell

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

timeshell

Incidentally, you should be able to get more information on why the job failed from the Job History. If you can provide information from there I could probably help you out more.