• Using Execute SQL tasks to run sp_start_job will not actually achieve that. sp_start_job will start a job and then finish - it does NOT wait for the job to finish. The job could run for hours. The SSIS package just described would (probably) run for less than a second and all 4 jobs will probably be executing at the same time.

    You will need to add code to wait for each job to finish (and you probably should check whether the job is currently running before attempting to start it. Otherwise, sp_start_job will report an error).

    Check out the code in sp_help_job - it has code that checks whether the job is running.