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: Thursday, June 4, 2015 7:12 AM
Points: 65, Visits: 373
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: Monday, July 27, 2015 4:47 PM
Points: 4,340, Visits: 7,203
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, June 4, 2015 7:12 AM
Points: 65, Visits: 373
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: Monday, July 27, 2015 4:47 PM
Points: 4,340, Visits: 7,203
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