Is it possible to run a Job from a stored procedure located in a different server? If so, how?
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With