I have a job that I manually start in coordinated time periods that does a bunch of heavy lifting (mostly restoring backups and configuring for a different server)
There are several jobs scheduled to run with increments of minutes to days. I want to "turn off" the scheduler so nothing will run on schedule until my manual job is done. I realize that missed jobs will not run again until their next scheduled time, after the scheduler is restarted.
- First Step: stop scheduler
- Several Heavy lifting steps: Do the hard work
- Last Step: start scheduler
I found An Oracle command but I am 100% Microsoft SQL Server
I know that if I Turn off the SQL agent, jobs will not run but that is not what I am looking for.
The jobs that exist for today, are not expected to be the same jobs next time. Disabling jobs with EXEC dbo.sp_update_job is not a viable solution.
Additional information: There may also be jobs in place that are intentionally disabled for some reason, that do want to be re-enabled. Stopping the scheduler seems like the best choice.