Calendar expressions for dbms_scheduler
Here are some examples of Calendar type instructions to schedule job executions for the Oracle dbms_scheduler scheduler: Replace line repeat_interval with the desired repeat interval. BEGIN sys.dbms_scheduler.create_job( job_name => ‘”SYSTEM”.”TEST”‘, job_type => ‘PLSQL_BLOCK’, job_action => ‘begin — Insert PL/SQL code here end;’, repeat_interval => ‘FREQ=YEARLY; BYDATE=0715;’, start_date => systimestamp at time zone ‘Europe/Paris’, job_class => ‘”DEFAULT_JOB_CLASS”‘, auto_drop => FALSE, enabled => TRUE); END; / Every day, monday to friday at 8PM FREQ=DAILY; BYDAY=MON,TUE,WED,THU,FRI; BYHOUR=20; BYMINUTE=0; BYSECOND=0; Every hour FREQ=HOURLY;INTERVAL=1; Every 5 … Read more