How to start an sql job by completion of other sql Jobs?

Question

I have 5 sql jobs. But I have to start the 5th sql job only when all other 4 sql jobs are been completed. Is it possible to achieve it?

Thanks in Advance,

Answer 1

You could organize your jobs in a maintenance plan.

Add nodes for each job and link the first four jobs to the fifth job (drag the arrow under the node). Right click the link between the jobs and select "completion". The fifth job will now wait until all previous jobs are finished executing.

Triggering the maintenance plan (either ad-hoc or with a schedule) will start parallel execution of the nodes without dependencies.