Friday, July 16, 2010

T-SQL to Disable/Enable Job in SQL Server 2005

T-SQL to Disable/Enable Job in SQL Server 2005

From the msdb..sysjobs, the required job_id for enable or disable to be taken.

select * from msdb..sysjobs

T-SQL to dis-enable specific job in sql server


EXEC msdb..sp_update_job @job_id = '770F175B-C8A0-4157-BACD-0AF129DF570C', @enabled = 0

T-SQL to enable specific job in sql server


EXEC msdb..sp_update_job @job_id = '770F175B-C8A0-4157-BACD-0AF129DF570C', @enabled = 1

1 comment: