patternMinor
Run two SQL Agent Jobs Simultaneously (not sequentially) as the next step
Viewed 0 times
thesqlagentnextjobstwosimultaneouslystepnotrun
Problem
At the completion of Step 1, the job currently goes to step 2 - an osql command to start a Sql Agent job on another server. However at the completion of step 1, I would also like to start a concurrent SQL Agent Job on the same server as the step 1 SQL Agent job. Right now, the jobs are cascaded but I would really like "job 2" and "Job 3" to run at the same time. Any ideas on how to make steps non- sequential?
Solution
You can try using the maintenance plans under management folder. There are Execute SQL Server Agent Job task and other task that fit your need. you can design the plan in the way that after a step completion, it run multiple tasks like shown below.
Context
StackExchange Database Administrators Q#42181, answer score: 5
Revisions (0)
No revisions yet.