May 3, 2007 at 3:52 am
Hi,
If you have two back up schedules for two different databases, if one of the schedules were on hold for sometime because of some reasons, how would it affect the second schedule?
( for e.g.: I have a back up schedule for a database at 12’0 clock.i have another back up schedule for another database at 12.05.If the first schedule got delayed for some reason, would it affect the second schedule?)
Thanks,
Geeth
May 3, 2007 at 5:15 am
Not sure how your jobs looks like, but in general if a job has multiple schedules and the job is still running from schedule1 while schedule2 kicks in, the second schedule will be ignored. So if your backups take quite long, make sure that the schedules are not conflicting. A better way might be having one jobfor database1 which on completion starts job 2 for the next database.
Markus
[font="Verdana"]Markus Bohse[/font]
May 3, 2007 at 8:47 am
Are these separate jobs in SQL Server or separate jobs in Windows scheduler?
Separate jobs ignore one another. If there are two steps, they go in order, not according to separate schedules.
As Markus mentioned, jobs are not re-entrant, meaning that a second instance cannot start when the first is running.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply