Problem with scheduled jobs

[Maritime]

Hi I'm runnning Windows 2000 server and SQL 2000. I have a particular job that is scheduled to run every 2 hours from 10:00 - 4:00, however for some reason the job keeps disabling itself and I have no idea why. When I think that the job ran, on checking I find that the scheduled portion of the job has disabled itself. I re enable the job but on checking a few hours later it's disabled again. Any ideas?

Thank

 

[mrdenny]

Make sure that there isn't an end date for the schedule.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[SQLBill]

Also, make sure that the schedule isn't set for one day or anything like that.

-SQLBill

Posting advice: FAQ481-4875