SQL one time job disabled after server reboot

• johnnie.vaneeden

  SSC Journeyman

  Points: 76

  More actions

  November 9, 2010 at 1:03 am

  #240922

  Hi

  Experienced something strange in my view. Scheduled a job to run once this afternoon. I restarted the server before the scheduled job's time and then the schedule of that job is disabled once the server is back up.

  Can anyone provide me with a reason for that and how I can prevent that from happening?

  Thanks

• nigelrivett

  SSCertifiable

  Points: 5472

  More actions

  November 10, 2010 at 6:30 am

  #1248811

  Are you sure you didn't do a test run of the job first which left it disabled?

  
  Cursors never.
  DTS - only when needed and never to control.