Post reply

SQL Server Agent - having jobs start based on previous job completion (on different SQL Servers)

  • January 16, 2009 at 9:13 am

    #205116

    For the jobs that are on the same SQL Server, I just use the sp_start_job command, but I can't do that when the job is on a different box because it's not apart of the sysjobs table. Do I use the isql.exe or an equivalent?

    Thanks in advance.

  • January 16, 2009 at 10:59 am

    #928357

    You could use the command line tool. Before going that direction, you may want to consider adding a linked server to the remote server. You would then be able to call LINKEDSERVERNAME.msdb.dbo.sp_start_job.

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

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