I want to create a job which should run once all the three jobs status are
COMPLETED or STOPPED or FAILED
I.e. When any of these jobs are running, that job should not start.
That is what 'Chains' are designed for. See 'Using Chains' in the DBA Guide
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.
Example 28-16 should give you what you want
The following example creates a chain where
my_program3run in parallel after