Job didn't run even though it was scheduled

• M&M

  SSC-Insane

  Points: 21700

  More actions

  March 11, 2009 at 4:46 pm

  #206871

  Hi,

  Faced a peculiar situation in SQL server 2000. There was a job which was scheduled at 4:00 am which didn't run at all. There was no error message nothing. Everything seem to be fine. The SQL server agent was running and didn't detect any issues. But I came across this error message from the SQL server Agent log when I ran the job manually.

  [156] Job 0x0D86A999CF4A2D44A19FFBAE7CC40630 does not exist in the job cache: attempting to re-acquire it from the server...

  Could you please advice on this. Just to update, yesterday the server was rebooted.

  M&M

• homebrew01

  SSC Guru

  Points: 55549

  More actions

  March 11, 2009 at 6:54 pm

  #958013

  I searched the Googles and found this:

  http://sqlforums.windowsitpro.com/web/forum/messageview.aspx?catid=60&threadid=42175&enterthread=y

• M&M

  SSC-Insane

  Points: 21700

  More actions

  March 11, 2009 at 7:31 pm

  #958026

  I found some links, but most of them are incomplete and don't seem relevant.

  Do I need to open a case with Microsoft. Also, just to add, failover was done by some other team yesterday before restarting the server.

  M&M