Viewing 3 posts - 1 through 3 (of 3 total)
Depending on why you want to turn off all jobs, we usually just stop Sql Server Agent. We would do this if the source server was going to be...
April 24, 2008 at 8:47 am
#806637
The way I learned some of the s/p's was to right click on the job and choose All tasks...Generate SQL script. That shows many s/p's used to create a job...
October 11, 2006 at 1:14 pm
#665291
It might be easier to use:
exec msdb..sp_update_job @job_name = 'Job Name', @enabled = 0
Paul (polecki@Insurance.com)
October 11, 2006 at 12:50 pm
#665287