September 17, 2010 at 5:00 am
Hi all
Tried to use sp_start_job from one sql server to another.
Starting from dwhousesql01 in management studio and changed to msdb:
EXEC sp_start_job
@server_name = 'dwhousesql02',
@job_name = 'Budget'
But it fails. I have googled this issue, and as I understand it, I can only use this if servers are linked?
Or I have to use osql.
No other options?
All I want is that when one particular job is done on dwhousesql01 it starts a new one on dwhousesql02.
Both servers are MS SQL 2005.
Anyone how knows a way around this?
Dan
September 17, 2010 at 5:59 am
i think you should go with the option you suggested - isql.
on server 1, job step1 should run on current server and job step 2 should call a command line/batch that should connect to server2 and execute the job.
September 17, 2010 at 6:06 am
as i replied
http://www.sqlservercentral.com/Forums/Topic987793-146-1.aspx
you need to create linked server for this.
----------
Ashish
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply