Home Forums SQL Server 2008 SQL Server 2008 - General Disabling job schedules RE: Disabling job schedules
Ant-Green
SSC Guru
Points: 113445
More actions
January 15, 2013 at 1:59 am
#1577184
Yep, query msdb.dbo.sysjobschedules, link it back to msdb.dbo.sysschedules to get the schedule id, pass it into sp_update_schedule with an enabled param of 0