Team,
The ORacle Version we use is :
Oracle Database 11g Release 11.2.0.4.0 - 64bit Production
Below is the code to generate a job by name LATE_FEE_CALC_FOR_PDL_LOANS to run at 4:15 AM EST daily.
BEGIN
dbms_scheduler.create_job(
job_name => 'LATE_FEE_CALC_FOR_PDL_LOANS'
,job_type => 'PLSQL_BLOCK'
,job_action => 'begin PRC_LATE_FEE(to_char(sysdate,''mm/dd/yyyy'')); end; '
,start_date => TIMESTAMP'2020-07-24 04:15:01 US/Eastern'
,repeat_interval => 'FREQ=DAILY'
,enabled => TRUE
,comments => 'scheduler for LATE FEE CALULATION FOR LOANS');
END;
Since on RAC Node DB, the load sharing would be done automatically where there would be little load.
Assuming we have 2 nodes on the RAC DB by names node1 and node2 , we want to run the above scheduler on node2 daily.
Any recommendations on this are most welcome.
Appreciate all your help !!
Thanks !!