Re: DBMS_SCHEDULER on RAC - Run on node2 if job in failed on node1

Hi

You can use JOB_CLASS.

Create 2 Job_Classes and each associated with your RAC Node 1 and 2 with custom db service for each Node.

JBC1 with Service -J1 to Node 1

JBC2 with Service -J2 to Node 2

Define Scheduler job to begin with JobClass JBC1 When it fails Alter failed job attribute JOB_CLASS to use JBC2 and restart.

HTH
Karth

Sent from my IPhone

> On Jun 17, 2024, at 2:33 PM, sumit Kumar Tyagi <dba.tyagisumit_at_gmail.com> wrote:
>
> 
> Hi All
>
> Looking for expert view on how to create dependency using dbms_scheduler
>
> Scenario :
>
> JOB =>
> -> Run on RAC node 1 : -> If successful END the workflow
> -> If RAC node 1 failed --> Attempt the job on node2 .
> -> If node2 is successful overall workflow should be success .
>
>
> Issue i am facing is oracle allow dbms_scheduler.define_chain_step to specify the "program" name but not the job_name . With program_name i am not able to specify to run the program on specific node1 or node 2 .
>
> --
>
> --
> BR
> Sumit Kumar Tyagi
> +91-7829543355

--
http://www.freelists.org/webpage/oracle-l