Jobs scheduled through DBMS_JOB do not start

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

 

 

Leave a Reply