Sharing Job Schedules

Most of us create a new schedule each time we create a new job, but we can actually reuse an existing schedule if we have one that fits. The upside is only having to change one schedule if a change is needed, and the downside is that changing the schedule changes it for all jobs using that schedule.

Andy Warren is a software trainer focusing on SQL Server, a member of the PASS Board of Directors, and a principal in this site - SQLShare.com.

Don Weigend on 11/18/2009

Job schedule sharing is an excellent feature, something that I haven't noticed before but I certainly can make use of it. Great tip!

Rod on 11/18/2009

I never knew you could do this. Very useful!

Brandie Tarvin on 11/18/2009

Would like to have seen what happens with a disabled schedule when it is changed.

Marco Francisco on 11/18/2009

Yes...nice post. This is very helpfull with subscription management...Very useful... Again, nice post.

alfred on 11/18/2009

ok

valluru raghu on 11/19/2009

Good

Dennis Allen on 11/19/2009

I would have liked more time given to how jobs that share schedules will run at the same time rather than following a sequence. It was mentioned at the end kind of quickly. Perhaps a greater discussion of Using one job to manage what is really a sequence of jobs/tasks as a contrast.

luther smith on 11/19/2009

Don't do it!

A Alagu Ganesh on 2/10/2010

Good

mengchew0113 on 5/12/2010

that's great. never thought can do this.

Steve Culshaw on 11/23/2010

Nice pointer