How to enable/disable a job scheduled in SQLServer Agent?
February 14th, 2010
No comments
Using msdb.dbo.sp_update_job one can disable or enable jobs, the job_id can be retrieved from msdb.dbo.sysjobs
To enable
EXEC msdb.dbo.sp_update_job @job_id, @enabled = 1
To disable
EXEC msdb.dbo.sp_update_job @job_id, @enabled = 0