Post reply

How to run the job (residing in one server) from different server

  • June 24, 2009 at 3:01 am

    #133377

    I have a job1 in Server A which pulls data from various sources and dumps it into some destination database. I want to call another job2 which exists in Server B, job2 needs to be invoked from Server A as one of the job steps in job1. What are the different approaches I can follow?

  • June 24, 2009 at 3:11 am

    #1014486

    1) Create a linked server

    2) execute sp_start_job in msdb

    eg

    execute serverB.msdb.dbo.sp_start_job 'Jobname'

    ----------------------------------------------------------------------------------------------------------------------------------------------------
    Roshan Joe

    Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

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