Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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: Thursday, August 11, 2016 6:10 AM
Points: 69, Visits: 427
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


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Wednesday, August 24, 2016 6:06 PM
Points: 4,717, Visits: 7,321
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: Thursday, August 11, 2016 6:10 AM
Points: 69, Visits: 427
TY!!
Post #1386519
Posted Monday, November 19, 2012 11:45 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Wednesday, August 24, 2016 6:06 PM
Points: 4,717, Visits: 7,321
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