SET NOCOUNT ON
--GENERATE SCRIPT TO DISABLE ALL ENABLED JOBS
PRINT '--DISABLE JOBS'
select 'exec msdb.dbo.sp_update_job @job_name = ''' + name + ''' , @enabled = 0;'
from msdb.dbo.sysjobs
where enabled = 1
--GENERATE SCRIPT TO ENABLE ALL DISABLED JOBS
PRINT '--ENABLE JOBS'
select 'exec msdb.dbo.sp_update_job @job_name = ''' + name + ''' , @enabled = 1;'
from msdb.dbo.sysjobs
where enabled = 1
Discover more from SQLyard
Subscribe to get the latest posts sent to your email.


