Dear Experts,
I tried to find one scheduler JOB Status on OCT 28 or OCT 29 but facing an error. Kindly help me to sort out below error.
SQL> alter session set nls_date_format='DD-MON-YY';
Session altered.
SQL> select OWNER,JOB_NAME,LOG_DATE,STATUS,RUN_DURATION from dba_scheduler_job_run_details
2 where job_name='PROD_SMS_OBJ SB_UPD_ENTY_NB_STTS_TRKNG_JOB' and log_date='29-OCT-20';
where job_name='PROD_SMS_OBJ SB_UPD_ENTY_NB_STTS_TRKNG_JOB' and log_date='29-OCT-20'
*
ERROR at line 2:
ORA-01840: input value not long enough for date format
Thanks in Advance.