SQL SERVER SCRIPT TO ENABLE OR DISABLE JOBS

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.

Leave a Reply

Discover more from SQLyard

Subscribe now to keep reading and get access to the full archive.

Continue reading