Schedule (Enabled check box) unchecking | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Schedule (Enabled check box) unchecking

Hi all, I have a simple question, as follows. I have set up a couple of jobs which I have scheduled to run around the same time each night. One of the jobs works fine, but the other does not run, I have looked into the problem and found that the tick box which enables scheduling, unchecks it’s self each night. Is this possible and how can I stop it. Both jobs were set-up in exactly the same manner. Cheers.

SQL Server will not disable the job itself(automatically) until unless any process requests to disable the job. Run PROFILER during the schedule of these jobs and see the process of statements. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Thanks for that idea, I will try that next run. Cheers
Also check if one job block other.
Luis Martin
Moderator All postings are provided “AS IS” with no warranties for accuracy.