Lets say i want to execute C and D at same time once B gets completed. I.e. I have dependency on B and i want to execute B proc first, once it gets completed then execute C and D at same time.
And all these 3 procs are in "A"
How to achieve this?
That is what 'Chains' are designed for. See 'Using Chains' in the DBA doc
A chain is a named series of tasks that are linked together for a combined objective. Chains are the means by which you can implement dependency based scheduling, in which jobs are started depending on the outcomes of one or more previous jobs.
To create and use a chain, you complete these tasks in order:
Task See... 1. Create a chain object Creating Chains 2. Define the steps in the chain Defining Chain Steps 3. Add rules Adding Rules to a Chain 4. Enable the chain Enabling Chains 5. Create a job (the "chain job") that points to the chain Creating Jobs for Chains
The doc has an example (28-16) of doing EXACTLY what you ask about
Example 28-16 Creating a Chain
The following example creates a chain where
my_program3run in parallel after