SQL Server Agent not running jobs

• arr.nagaraj

  SSCertifiable

  Points: 6528

  More actions

  July 19, 2011 at 11:20 pm

  #97959

  Dear All,

  On one of the production SQL Server 2000 instances, the SQL Agent was up and running but none of the jobs executed after a particular date(25/06). No job history was found after the 25th June. when the job was executed manually, it didnt create any job history.A restart fixed the issue but we wanted to know what could caused sucha a issue. What are the possibilites

  Regards,

  Raj

  Regards,
  Raj

  http://Strictlysql.blogspot.com

• Meet George Jetson

  SSChampion

  Points: 11614

  More actions

  July 21, 2011 at 12:40 pm

  #1356668

  Just a guess, but you may have hit the maximum job history log size.

  Chris Powell

  George: You're kidding.
  Elroy: Nope.
  George: Then lie to me and say you're kidding.