SQL Server Performance Forum – Threads Archive
Schedule (Enabled check box) uncheckingHi 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.
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.