Monday, March 5, 2012

Enable / Disable schedules of SQL Job -Tsql

EXEC msdb.dbo.sp_attach_schedule @job_name=N'Job Name',@schedule_id=51
GO
USE [msdb]
GO
EXEC msdb.dbo.sp_update_schedule @schedule_id=51,
@enabled=0
GO


EXEC msdb.dbo.sp_attach_schedule @job_name=N'Job Name',@schedule_id=51
GO
USE [msdb]
GO
EXEC msdb.dbo.sp_update_schedule @schedule_id=51,
@enabled=1
GO

No comments:

Post a Comment