Disabling job schedules

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

  • sp_update_schedule

    sp_update_jobschedule

  • 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

  • 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