Thinking
Friday, November 26, 2010
disable and enable jobs
USE [msdb]
GO
EXEC msdb.dbo.sp_update_job @job_id=N'51228a93-6a7c-4086-8cc2-bd1dfa60677d',
@enabled=1
GO
USE [msdb]
GO
EXEC msdb.dbo.sp_update_job @job_id=N'51228a93-6a7c-4086-8cc2-bd1dfa60677d',
@enabled=0
GO
No comments:
Post a Comment
‹
›
Home
View web version
No comments:
Post a Comment