Revisions to Running a Job from a Stored Procedure in another server?

Just cleaning up formatting

Source Link

edited May 20, 2013 at 14:09

181.5k
28
402
619

You can have the Sql Jobjob in a stored Procedure in server B.Add Add server B as linked server to Server A,Execute Execute the stored Procedure Procedure from server A EXEC [RemoteServer] .DatabaseName.DatabaseOwner.StoredProcedureName:

EXEC [RemoteServer].DatabaseName.DatabaseOwner.StoredProcedureName

You can have the Sql Job in a stored Procedure in server B.Add server B as linked server to Server A,Execute the stored Procedure from server A EXEC [RemoteServer] .DatabaseName.DatabaseOwner.StoredProcedureName

You can have the Sql job in a stored Procedure in server B. Add server B as linked server to Server A, Execute the stored Procedure from server A:

EXEC [RemoteServer].DatabaseName.DatabaseOwner.StoredProcedureName

Post Migrated Here from stackoverflow.com (revisions)

occurred Apr 25, 2013 at 10:14

Source Link

created Apr 25, 2013 at 6:50

I am legend

You can have the Sql Job in a stored Procedure in server B.Add server B as linked server to Server A,Execute the stored Procedure from server A EXEC [RemoteServer] .DatabaseName.DatabaseOwner.StoredProcedureName

Stack Exchange Network

Return to Answer