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: Wednesday, September 14, 2016 6:47 AM
Points: 71, Visits: 434
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: Today @ 6:00 AM
Points: 4,717, Visits: 7,334
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: Wednesday, September 14, 2016 6:47 AM
Points: 71, Visits: 434
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: Today @ 6:00 AM
Points: 4,717, Visits: 7,334
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