InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 23:34:06 GMT20http://www.sqlservercentral.com/Forums/Topic1407078-391-1.aspxYep, 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 0Tue, 15 Jan 2013 01:59:37 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1407078-391-1.aspxAnthonytrying out sp_update_jobschedule. How to get schedule name of an job. I would get all job names, schedule name and use the above stored proc to disable all scheduleTue, 15 Jan 2013 01:56:33 GMTbalasach82http://www.sqlservercentral.com/Forums/Topic1407078-391-1.aspxsp_update_schedulesp_update_jobscheduleTue, 15 Jan 2013 01:41:24 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1407078-391-1.aspxIs there an way to disable all jobs schedules? I dont want to stop agent.Tue, 15 Jan 2013 01:38:14 GMTbalasach82