SQL Server Agent not running jobs

  • 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

  • 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.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply