I am trying to build a query with a cursor that queries a table with detailed server names. The idea behind the query is to have the cursor loop through the table, grab the server name and run a stored procedure "msdb.dbo.sp_start_job @job_Name = 'FC Updates', @server_name = @srvname". I want the stored procedure to start a job remotely on the allocated server in the table named "FC Updates". I am receiving an error:
"Msg 14262, Level 16, State 1, Procedure sp_verify_job_identifiers,
The specified @job_name ('FC Updates') does not exist."
Any ideas? Query is attached.