sp_start_job

• @DJ

  SSCommitted

  Points: 1989

  More actions

  September 27, 2010 at 1:55 am

  #145405

  Hi all

  Posted this on the sql 7,200 tread by a mistake, so I will try it here as well.

  Tried to use sp_start_job from one sql server to another.

  Starting from dwhousesql01 in management studio and changed to msdb:

  EXEC sp_start_job

  @server_name = 'dwhousesql02',

  @job_name = 'Budget'

  But it fails. I have googled this issue, and as I understand it, I can only use this if servers are linked or I have to use osql?

  No other options?

  All I want is that when one particular job is done on dwhousesql01 it starts a new one on dwhousesql02.

  Both servers are MS SQL 2005.

  Anyone how knows a way around this?

  Thanks for any comments

• crazy4sql

  SSCoach

  Points: 19590

  More actions

  September 27, 2010 at 2:00 am

  #1227557

  yes, first you need to create the linked server.

  Once you created the linked server then

  use msdb

  go

  exec [your linked server name].msdb.dbo.sp_start_job

  @job_name = 'job name on remote server'

  ,@server_name='[ your original destination server name(with instance if applicable)]'

  ----------
  Ashish