log information for all Scheduler jobs - Oracle Database Script. SET pagesize 299 SET lines 299 col job_name FOR a24 col log_date FOR a40 col OPERATION FOR a19 col additional_info a79 SELECT job_name, log_date, status, OPERATION, ADDITIONAL_INFO FROM dba_scheduler_job_log ORDER BY log_date DESC;
SET pagesize 299 SET lines 299 col job_name FOR a24 col log_date FOR a40 col OPERATION FOR a19 col additional_info a79 SELECT job_name, log_date, status, OPERATION, ADDITIONAL_INFO FROM dba_scheduler_job_log ORDER BY log_date DESC;