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

sql-server sql-server-2005 sql-server-2008 sql-agent
Feckmore picture Feckmore · Jun 25, 2010 · Viewed 10.1k times · Source

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

Baaju picture Baaju · Jun 25, 2010

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.

Related questions

How to avoid the "divide by zero" error in SQL?

I have this error message: Msg 8134, Level 16, State 1, Line 1 Divide by zero error encountered. What is the best way to write SQL code so that I will never see this error message again? I could do either of the following: …

Read More
SQL Server query to find all permissions/access for all users in a database

I would like to write a query on a sql 2008 that will report all the users that have access to a specific database, or objects within the database such as tables, views, and stored procedures, either directly or due to …

Read More
sql query to return differences between two tables

I am trying to compare two tables, SQL Server, to verify some data. I want to return all the rows from both tables where data is either in one or the other. In essence, I want to show all the …

Read More