List of jobs and jobs history - PL/SQL

ALL_SCHEDULER_JOBS displays information about the Scheduler jobs accessible to the current user.

SELECT * FROM ALL_SCHEDULER_JOBS;   

DBA_SCHEDULER_JOBS displays information about all Scheduler jobs in the database.

SELECT * FROM DBA_SCHEDULER_JOBS;   

USER_SCHEDULER_JOBS displays information about the Scheduler jobs owned by the current user. This view does not display the OWNER column.

SELECT * FROM USER_SCHEDULER_JOBS;   

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;
Refernces

Oracle Doc


Read More