We are running SQL 2000. I have one job that has 3 different schedules in it. It is scheduled to run Mon-Fri every 5 mins from 8:00 to 8:30. It's also scheduled to run every 10 mins from 10:00 to 11:00 and every half hour from 2:00 to 6:00. So there are 3 different schedules inside one job. The problem is that these 3 jobs seem to disable themselves at random. I can enable them and close the job, when I open it again at least one of them is now disabled. I've tried re-scheduling them and changing the dates or times slightly and the same thing happens. Any ideas?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Scheduled jobs disabling themselves
- Thread starter JH123
- Start date
Similar threads
- Locked
- Question
- Locked
- Question