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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-05-17 : 10:08:44
|
| Jon Osmond writes "Hi - I have written a stored procedure to backup a database to a location on an external server. The restore database stored procedure, seems to have to run on the external server and I just wanted to know if it's possible to fire the restore database stored procedure (that resides on the external database) from the local server Catch me drift??" |
|
|
VyasKN
SQL Server MVP & SQLTeam MVY
313 Posts |
Posted - 2002-05-17 : 10:25:08
|
| Yes, you can, if you know the job name and you have a linked server pointing to the remote server, on your local server. Then you run the following on your local server:EXEC RemoteServer.msdb.dbo.sp_start_job @job_name = 'RestoreJobName'--HTH,Vyashttp://vyaskn.tripod.com |
 |
|
|
|
|
|
SQL Schedulin'