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!

Need to get details about one Failed Job details between specific date ranges

JhilDec 26 2020

I am trying to get output about one specific failed Job on 28th and 29 th OCT date.
SQL> select OWNER,JOB_NAME,LOG_DATE,STATUS,RUN_DURATION from dba_scheduler_job_run_details
where job_name='SB_UPD_ENTY_NB_STTS_TRKNG_JOB' AND
log_date between TO_TIMESTAMP_TZ ('28-OCT-2020', 'DD-MON-YYYY')
AND TO_TIMESTAMP_TZ ('29-OCT-2020', 'DD-MON-YYYY') ; 2 3
no rows selected
Thanks in Advance.
DB : 19c

Added on Dec 26 2020

8 comments

3,225 views