T-SQL:
Disable All SQL Jobs:
SELECT 'Exec MSDB..sp_update_job @job_name = '''+NAME+''', @enabled = 0' FROM MSDB..sysjobs order by name asc
Enable All SQL Jobs:
SELECT 'Exec MSDB..sp_update_job @job_name = '''+NAME+''', @enabled = 1' FROM MSDB..sysjobs order by name asc
Check All SQL Jobs Enabled Status:
Select [enabled], name from MSDB.dbo.sysjobs order by name asc
|
|
|
|
|
|