sandosh.star (8/1/2013)
how to trigger a job after completion of another job in sql server management studio 2005I have two JOBS A and B in JOB Activity monitor
I want to trigger JOB B automatically after completion of JOB A
Add a step of type "Transact-SQL script (T-SQL)" to the end of Job A. In the "Command" window for that step, enter a statement that executes the sp_start_job system stored procedure for Job B. See here for info on sp_start_job:
http://msdn.microsoft.com/en-us/library/ms186757(v=sql.90).aspx
Jason Wolfkill