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

Hi Karth

Thanks for the inputs . I tried same and manage to run the job on node1 or node2 based on service but the problem is I can’t manually alter it each time on failure ( this is not one job) we will be scheduling this across 1000s of databases . I am looking for something if we have any way in dbms scheduler to create chain for jobs similar to how we define chain rules for dbms scheduler programs .

--
BR
Sumit Kumar Tyagi
+91-7829543355


On Tue, 18 Jun 2024 at 12:25 AM, Karthikeyan Panchanathan <
keyantech_at_gmail.com> wrote:



> 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