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;
Use the share button below if you liked it.
It makes me smile, when I see it.