If a scheduled job via dbms_job won’t start, allthough job_queue_processes > 0:
1: kill the ora-cjq0-[SID] process on the OS
2: change job_queue_processes to 0 and back to 10 (or other value)
The ora-cjq0 process will restart to serve dbms_jobs
If a scheduled job via dbms_job won’t start, allthough job_queue_processes > 0:
1: kill the ora-cjq0-[SID] process on the OS
2: change job_queue_processes to 0 and back to 10 (or other value)
The ora-cjq0 process will restart to serve dbms_jobs