Post reply

have a job step execute a job on another server

  • November 15, 2012 at 4:45 pm

    #393611

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

    Thanks

  • November 15, 2012 at 7:46 pm

    #1559586

    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

  • November 19, 2012 at 11:33 am

    #1560472

    TY!!

  • November 19, 2012 at 11:45 am

    #1560477

    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