Sql-server – Running a Job from a Stored Procedure in another server

jobslinked-serversql serverstored-procedures

How can I run a job from another server using a stored procedure?

Let's say

  • server 1 : db1
  • server 2 : db2
  • username : testssis
  • password : testssispass
  • sqljob found in db2: job1

Here is the part im lost with how can I make this work? 

xp_cmdshell + osql command -U: -P: + sp_startjob

Best Answer

With a linked server - much more reliable and secure than xp_cmdshell:

EXEC Server2.msdb.dbo.sp_start_job @job_name = N'Job2';
Related Question