Post reply

Disabling job schedules

  • January 15, 2013 at 1:38 am

    #269206

    Is there an way to disable all jobs schedules? I dont want to stop agent.

  • January 15, 2013 at 1:41 am

    #1577178

    sp_update_schedule

    sp_update_jobschedule

  • January 15, 2013 at 1:56 am

    #1577183

    Anthony

    trying 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 schedule

  • 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

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply