Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

have a job step execute a job on another server Expand / Collapse
Author
Message
Posted Thursday, November 15, 2012 4:45 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Today @ 8:14 AM
Points: 51, Visits: 302
i need the last step of a job to execute a job on another server. Can someone post that command?

Thanks
Post #1385397
Posted Thursday, November 15, 2012 7:46 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, July 14, 2014 2:06 PM
Points: 3,865, Visits: 7,130
Well this depends...Can you use a linked server? If so, it's quite simple
EXECUTE [YOURSERVER].msdb.dbo.sp_start_job 'TESTJOB'



______________________________________________________________________________
"Never argue with an idiot; They'll drag you down to their level and beat you with experience"
Post #1385428
Posted Monday, November 19, 2012 11:33 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Today @ 8:14 AM
Points: 51, Visits: 302
TY!!
Post #1386519
Posted Monday, November 19, 2012 11:45 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, July 14, 2014 2:06 PM
Points: 3,865, Visits: 7,130
No problem, hope it works out for you

______________________________________________________________________________
"Never argue with an idiot; They'll drag you down to their level and beat you with experience"
Post #1386526
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse