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.