This content has been marked as final. Show 2 replies
-You could Check Alertlog for this , Since Oracle Inform you there's Failed Executed Job .1 person found this helpful
-you could use
SELECT TIMESTAMP, job_name, status,ADDITIONAL_INFO FROM user_scheduler_job_run_details WHERE job_name = 'JOB_NAME' Or SELECT JOB FROM DBA_JOBS WHERE BROKEN = 'Y'; OR SELECT FAILURES, JOB FROM DBA_JOBS;
What are the errors that are being reported ?