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 - 2003-10-20 : 08:25:20
|
| sheing writes "Hello,I'd like to ask about sp_start_job arguments.I need to execute job in another server,so I have this query:EXEC msdb.dbo.sp_start_job @job_name = 'JOBNAME', @server_name = 'SVRNAME'but I got this message:Server: Msg 14262, Level 16, State 1, Procedure sp_verify_job_identifiers, Line 61The specified @job_name ('JOBNAME') does not exist.How to execute job in another server?Thank you...Regards,She Ing" |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-10-20 : 08:27:38
|
| Which server does the Job exist on ? The local one or the remote one ?Damian |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-10-20 : 12:27:27
|
| If you haven't configured Multi-server administration, then you'll need to specify the server name when calling sp_start_job:EXEC Server1.msdb.dbo.sp_start_job...You'll need a linked server for this.@server_name is used when you have multi-server administration configured.Tara |
|
|
|
|
|
|
sp_start_job