job problem

[pandatime]

Hi,

I am seeing something very strange. After some issues with the server last week (a shutdown of a database after the templog got too big and couldn't grow due to a size restriction), the sql server agent wouldn't start properly.

We solved the problem by rebooting the server and everything seemed ok after that. However, now I'm seeing a situation where daily scheduled jobs simply are not running. No error message, nothing. Just don't run, period. However, it's just some of the daily jobs, not all of them, that are having this problem.

Anyways, I rebuilt the jobs in the hope that will solve the problem.

Has anyone ever seen this problem before? It's unsettling.

 

[klewis10367]

Dumb question but are you sure the SQl Server Agent is running? If not set up to autostart when SQL Server starts your jobs will not run.

 

[djj55]

klewis10367 is correct in that SQL Server Agent is not set to start automatically by default and if you stopped the database service then the SQL Server Agent was stopped also.

djj
The Lord is My Shepard (Psalm 23) - I need someone to lead me!