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 |
|
honey_191
Starting Member
49 Posts |
 Posted - 2008-02-03 : 05:06:24
|
| I have 2 jobs in first job,there are 2 stepsin the 1st step it has to take the backupin the 2nd step it has to call the 2nd jobin 2nd job,it has to restore the backupi dont know how to call another job in the second step and one more thing is the restoration is done on another sql server instance |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-02-03 : 11:18:48
|
| so what is your Questions |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-03 : 13:50:10
|
| You can start job with msdb..sp_start_job. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-03 : 15:23:41
|
| >> restoration is done on another sql server instanceYou can run restore statement in sqlcmd, just specify remote server with -S option. |
|
|
|
|
|
|
jobs