SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Scheduler by INTERVAL

JhilDec 16 2020

Dear Experts,
I have some confusion about Scheduler Jobs.
I could understand that Jobs are running every hour but INTERVAL means , what it is pointing from below output ?

JOB_NAME REPEAT_INTERVAL LAST_START_DATE
----------------------------------- ------------------------------------------------------- ----------------------------
CLEAR_NON_EXIST_OBJS FREQ = HOURLY; INTERVAL = 12 16-DEC-20 02.49.41.155262 AM +00:00
CLEEAR_IND_BUILD FREQ = HOURLY; INTERVAL = 1 16-DEC-20 02.22.14.072906 PM +00:00
CLEAR_MMB FREQ = HOURLY; INTERVAL = 4 16-DEC-20 02.26.06.190758 PM +00:00
CLEAR_TRANS_PKG FREQ = HOURLY; INTERVAL = 2 16-DEC-20 02.25.56.192443 PM +00:00

Thanks

This post has been answered by Frank Kulash on Dec 16 2020

Jump to Answer

Added on Dec 16 2020

4 comments

431 views

1 mention