Login  Register

Re: Oracle job is not running

Posted by ErmanArslansOracleBlog on Sep 18, 2017; 8:26am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Oracle-job-is-not-running-tp3400p3507.html

Aha.. Your job_queue_processes parameter was set to 0!!

Starting with Oracle Database release 11.2.0.1, setting JOB_QUEUE_PROCESSES to 0 causes both DBMS_SCHEDULER and DBMS_JOB jobs to not run.
Previosly, it was not like that.. (setting JOB_QUEUE_PROCESSES to 0 caused DBMS_JOB jobs to not run, but DBMS_SCHEDULER jobs were unaffected and would still run)

If you would mention that, no jobs could be running , we could go to the solution faster.. :)

But good for you Arsala.!
thanks for sharing.