Some view to find out which jobs are in the queue to be executed

oracle

A environment start several refreshes along the day.

enter image description here

If I change the job_queue_processes to 20 for example, it start several new jobs. Is there some view that I can see which jobs is waiting and will be executed if I change the job_queue_processes?

Observation: the jobs have been created with dbms_job.

Best Answer

For Oracle versions prior to 19c you can check the DBA_JOBS view for job created with the DBMS_JOBS package. For jobs created using DBMS_JOBS in Oracle 19c and later, or for jobs created with the DBMS_SCHEDULER in any version, check the DBA_SCHEDULER_JOBS view.