...
| Code Block |
|---|
BEGIN
SYS.DBMS_SCHEDULER.DROP_SCHEDULE
(schedule_name => 'CAMIS.SCHED_HALF_YEARLY');
END;
/
BEGIN
SYS.DBMS_SCHEDULER.CREATE_SCHEDULE
(
schedule_name => 'CAMIS.SCHED_HALF_YEARLY'
,start_date => TO_TIMESTAMP_TZ('2021/06/15 14:00:00.000000 -04:00','yyyy/mm/dd hh24:mi:ss.ff tzr')
,repeat_interval => 'FREQ=monthly; INTERVAL=6; BYDAY=1TUE;BYHOUR=00; BYMINUTE=0; BYSECOND=30'
,end_date => NULL
,comments => 'Running the first Tuesday, every six months at 0000:00:30hrs (30 sec after midnight)'
);
END;
/
|
..TEST