Dear All,
Oracle information : Oracle Autonomous Database (19c)
I setted the repeat time of DBMS_SCHEDULER as 2 minutes.
However, the scheduler is running every 2 hours and 2 minutes.
- SCHEDULER_TYPE : PLSQL
- START_DATE : 24/06/14 18:16:04.000000000 EUROPE/BERLIN
- REPEAT_INTERVAL : SYSDATE +0+0/24+2/1440+0/86400
- LAST_START_DATE : 24/06/19 00:16:33.049898000 GMT
- NEXT_RUN_DATE : 24/06/20 02:16:33.000000000 GMT
Other scheduler's time set to repeat is 1 day and it also is running 1 day and 2 hours.
- REPEAT_INTERVAL : SYSDATE +1+0/24+0/1440+0/86400
Why these schedulers delay 2 hours?
One of the scheduler is running successfully and this scheduler info like below.
- SCHEDULER_TYPE : CALENDAR
- START_DATE : 24/05/16 12:15:44.000000000 EUROPE/PARIS
- REPEAT_DATE : FREQ=DAILY;INTERVAL=1
- LAST_START_DATE : 24/06/19 12:15:44.276919000 EUROPE/PARIS
- NEXT_RUN_DATE : 24/06/20 12:15:44.279094000 EUROPE/PARIS
Kindly request you to help in this regards.
Chloe.