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
Moderator
http://www.SQL-Server-Performance.Com/forum
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
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

]]>