Running SQL agent job from SSIS

1
votes

I want to run SQL agent job from SSIS package and make sure the control comes back to SSIS after job completes and executes the next task in the package. Is this possible?

Please let me know if there is any solution.

1
sqlsql-serverssis
Check out the Execute Sql Server Agent Job Task task .. msdn.microsoft.com/en-us/library/ms137858.aspx – Doolius

1 Answers

0
votes

You have at least two viable options. Create an Execute SQL Task and use sp_start_job, or use the Execute SQL Server Agent Job Task.