Check the Details of which scheduled jobs are finished with error.

Description:

Check the Details of which scheduled jobs are finished with error in database level.

Query:

set head on;
set feed off;
set pages 0;
set verify off;
set feedback off;
set linesize 250;
select owner||’,’||job_name||’,’||status||’,’||actual_start_date||’,’||run_duration from dba_scheduler_job_run_details where trunc(actual_start_date)=trunc(sysdate-1) and (status=’FAILED’ OR output like ‘%ERROR%’OR additional_info like ‘%ORA-%’);
exit;