Home Forums SQL Server 7,2000 SQL Server Agent Start Agent Job on another Server RE: Start Agent Job on another Server

  • 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