Home Forums SQL Server 7,2000 SQL Server Agent Start Agent Job on another Server RE: Start Agent Job on another Server
Green Armchair
Hall of Fame
Points: 3561
More actions
January 8, 2004 at 2:10 am
#489087
Thanks Thomas, I couldn't find syjobexecute, but I succesfully used:
linkedserver.Master.dbo.sp_ExecuteSQL N'EXEC msdb.dbo.sp_start_job @job_name = "Test Job"'
Andy