Linked Server

  • I need to set up job to run from linked server, how do I call it in a code of the job?

  • if u have already added the linked server then all you need to do is:

    exec servername.msdb..sp_start_job @job_name = 'name of the job on the linked server'

    4 part naming is your friend.

    -----------------------------
    www.cbtr.net
    .: SQL Backup Admin Tool[/url] :.

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

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