Home -> Mailing Lists -> Oracle-L -> DBMS_SCHEDULER on RAC - Run on node2 if job in failed on node1

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

From: sumit Kumar Tyagi <dba.tyagisumit_at_gmail.com>
Date: Tue, 18 Jun 2024 00:01:32 +0530
Message-ID: <CAFW4NVw289VGxhsYONR8Phevt4S24hDRLufJNVLNBPvdLPxFGQ_at_mail.gmail.com> 





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


Received on Mon Jun 17 2024 - 20:31:32 CEST












Original text of this message