Sometimes you want to run something just in one node of the RAC. Here is an example to do it:
create or replace procedure USER_JOB.PRC_SOMETHING is begin -- do something null; end; /
begin sys.dbms_scheduler.create_job(job_name => 'USER_JOB.JOB_SOMETHING', job_type => 'PLSQL_BLOCK', job_action => 'USER_JOB.PRC_SOMETHING;', start_date => sysdate, repeat_interval => 'Freq=Minutely;Interval=30', end_date => to_date(null), job_class => 'DEFAULT_JOB_CLASS', enabled => true, auto_drop => false, comments => 'Something Job.'); end; /
begin dbms_scheduler.set_attribute(name => 'USER_JOB.JOB_SOMETHING', attribute=>'INSTANCE_ID', value=> 1); end; /
Matheus.
