question

sandeepgowdams avatar image
sandeepgowdams asked

Jobs Scheduler

Job Schedule in SQL server agent Scenario 1 Job 2 ,job 3,job5 and job 6 need to run parallel after completion of Job 1 Successful . Job 4 will run sequential after completion of job 3 Job7 and job 8 will run sequential after completion of job 5 . Scenario 2 If support team need to skip some of the job how to do in scheduler to run particular job . (If any master table is created in db based on information we are able to do or any other option ) Please suggest for above requirement as soon as possible thanks in advance .
scheduling
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
sqlaj 1 avatar image
sqlaj 1 answered
- Have job 1 execute the other jobs (Job 2 ,job 3,job5 and job 6) after success - The same would go for job4, to execute job3 - The same would go for job4, to execute job3 The jobs being called from another job wont get schedules. They will run under the schedule of the calling job. As for the support team "need to skip some of the job..." That is something you and your team will need to decide. Like, criteria would need to be met for support "skip some of the job..."?
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.