have a job step execute a job on another server

  • i need the last step of a job to execute a job on another server. Can someone post that command?

    Thanks

  • 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; Theyll drag you down to their level and beat you with experience

  • TY!!

  • No problem, hope it works out for you 🙂

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply