John Mitchell-245523 (12/21/2012)
I would guess that you can't start a job remotely via a linked server. You could try using Powershell or SSIS instead. Or you could set up some triggers on the remote server so that they fire jobs when you update a table.John
Incorrect. You can very easily start a job remotely on a linked server. I would however, recommend you that you use the job uniqueidentifier rather than passing in the job name itself (although it should work either way) - what options did you configure for your linked server?
Example:
DECLARE @job_id uniqueidentifier
SET @job_id = '80209C18-A8AD-48BA-8D6B-10D785FE4383'
EXECUTE [LinkedServer].msdb.dbo.sp_start_job @job_id
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience