We have moved to a new website!

If you are not redirected within 3 seconds, click here to go my homepage.

List of jobs and jobs history - PL/SQL

PL SQL Query to list the currently running jobs

SELECT job_name, session_id, running_instance, elapsed_time, cpu_used 
FROM dba_scheduler_running_jobs;

To view the jobs history

SELECT job_name, log_date, status, actual_start_date, run_duration, cpu_used 
FROM dba_scheduler_job_run_details;   

Read More