Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to run a Job from a Stored Procedure in another server?

Is it possible to run a Job from a stored procedure located in a different server? If so, how?

like image 378
Francisco Noriega Avatar asked Nov 28 '25 16:11

Francisco Noriega


1 Answers

So why not consider using

exec LINKEDSERVERNAME.msdb.dbo.sp_start_job 'Job Name'

?

(didn't test it though, maybe some-unseen-answer was the same, but erased as incorrect and not working)

There must be enough privileges for linked-server-login to run the job, of course - at least it has to be job's owner.

like image 111
Aleksei Lychev Avatar answered Dec 01 '25 10:12

Aleksei Lychev