Calling a SQL Agent Job from another Job on a remote server?

Question

Is there a way to trigger a job on a from another job on a remote server without using Linked Servers?

The reasoning is that the job being triggered executes an SSIS package on 2008. The calling job resides on a 2005 server, so cannot execute the job directly.

The servers are not linked, and I was hoping there was a way to call one from the other.

Answer 1

Use the type "cmdexec (operating system)" in the SQL Agent and then use the dtexec \f "....." command line utily to execute SSIS 2008 package. This shud work !

Export the dtsx file to the 2005 server box and call the dtsx from command line using dtexec utility.

Answer 2

Not sure if this will work. Create a http end point that calls sp_start_job

http://technet.microsoft.com/en-us/library/ms181591.aspx

http://msdn.microsoft.com/en-us/library/ms186757.aspx