|
Author:
Author Bio:
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.
|
|
|
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.
|
Video Information
|
Publish Date:
|
November 13, 2009
|
Length:
|
1:13
|
Skill Level:
|
100
|
Rating:
|
4.08 out of 5
|
|
|
|
|
|
Watch Video Now! Watch it later!
|
|
|
|
|
|
Comments:
|
|
Job schedule sharing is an excellent feature, something that I haven't noticed before but I certainly can make use of it. Great tip!
|
|
|
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.
|
|
|
Yes...nice post. This is very helpfull with subscription management...Very useful...
Again, nice post.
|
|
|
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!
|
|
|
Good
|
|
mengchew0113 on 5/12/2010
that's great. never thought can do this.
|
|
|
|
|
|
|