A environment start several refreshes along the day.
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.