Calendar expressions for dbms_scheduler

by

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

DRA: Data Recovery Advisor

by

The data recovery advisor makes it possible to detect corruption or loss of data, determines the actions to be carried out and suggests the actions to be taken to repair the database. This can saves you lots of hours if you are not sure what you can do. LIST FAILURE The LIST FAILURE command allows … Read more