Jobs not running in SQL 2005

• Elliott Berkihiser

  SSCarpal Tunnel

  Points: 4068

  More actions

  November 8, 2006 at 11:00 am

  #170997

  Jobs which have run successfully before are failing with the message "Unable to retreive steps for job xxx".

  This is weird because the affected jobs are listed in msdb.dbo.sysjobs and the job steps are listed in msdb.dbo.sysjobsteps.  Also, SQL Server Agent is running.

  Has anyone seen this before?

  thanks, elliott

• Elliott Berkihiser

  SSCarpal Tunnel

  Points: 4068

  More actions

  November 8, 2006 at 12:29 pm

  #670684

  OK, I went to Services and re-started SQL Server Agent to fix the problem. 

  I have no idea what occurred to this service while I was gone, but I am going to talk to a couple of developers (who shall remain nameless)

  Elliott