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