Total Pageviews

Wednesday 2 May 2012

Jobs status in oracle

SELECT TO_CHAR(log_date, 'DD-MON-YY HH24:MM:SS') TIMESTAMP, job_name, status,
SUBSTR(additional_info, 1, 40) ADDITIONAL_INFO
FROM ALL_scheduler_job_run_details
ORDER BY log_date;

No comments:

Post a Comment