Database Administration (MOSC)

MOSC Banner

DBMS_SCHEDULER Job dependency Problem

edited Aug 18, 2009 11:39PM in Database Administration (MOSC) 1 commentAnswered
  I have a question about DBMS_SCHEDULER. I have created two chains, chain_A and chain_B. Created two jobs as job_type CHAIN - Job_A for chain_A and Job_B for chain_B.

I want to make sure that Job_A should not start if Job_B is running and Job_B should not start if Job_A is running.

But no job is dependent on each other that means if Job_A is finished then Job_B need not be started and if Job_B is finished then Job_A need not be started.

And as these jobs are not dependent on each other, they cannot be in the same chain steps, they need to be defined in different chains as the

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center