Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
loiter99
Starting Member
38 Posts |
 Posted - 2004-07-09 : 15:15:31
|
| Hello, I don't want to guess how long a backup takes and try to schedule a time for the next job to start. Is it possible to have one backup job fire off a separate backup job when it is complete?thanksJ |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-07-09 : 15:24:49
|
| You would put the second job as a second task in the job steps. So if you are backing up 3 databases, then you would have three job steps all in one job.And if you are backing up multiple databases, you might consider using this:http://weblogs.sqlteam.com/tarad/archive/2004/06/16/1607.aspxTara |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-07-09 : 23:32:33
|
| As the next step, you can just use:EXEC sp_start_job 'whatever I felt like calling it at 3:00 in the morning'MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
loiter99
Starting Member
38 Posts |
Posted - 2004-07-10 : 09:25:55
|
| Thank you both, that is exactly what I needed.Ps: Tara, I am using your SP,it is working great (as you already know) thanks ! |
|
|
|
|
|
|
Job executes another job