SQL 2000 agent looses scheduling

• Stags

  SSC Enthusiast

  Points: 190

  More actions

  February 5, 2010 at 1:57 am

  #98983

  Hi Guys

  I have a SQL 2000 server, which on 3 occasions now has lost the scheduling date and time for the jobs. The agent is still running but none of the jobs are scheduled and therefore none of the jobs start. If I stop and start the agent then everything is back to normal. Any idea what would cause this and what I can do to fix this?

• Chandra Sekhara Vyas Dhara

  SSChampion

  Points: 10207

  More actions

  February 5, 2010 at 2:45 am

  #1114266

  Duplicate Post

• Stags

  SSC Enthusiast

  Points: 190

  More actions

  February 5, 2010 at 2:52 am

  #1114267

  Thats correct. I had initially posted it in the incorrect forum ...

  Please forgive the rookie ...