Post reply

SQL Agent Job dependency between two Servers

  • August 31, 2018 at 12:28 pm

    #362285

    Is there a way to set dependency between two SQL Server agent jobs that are not in the same server beside using a linked server?

  • August 31, 2018 at 2:51 pm

    #2004190

    Another option may be to have an "Operating System" step that calls SQLCMD on the second server using the command:
    EXEC msdb.dbo.sp_start_job @job_name = 'yourjobnamehere'

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

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