Home -> Mailing Lists -> Oracle-L -> scheduler jobs not running.

scheduler jobs not running.

From: Terrian, Thomas J CTR DLA INFO OPERATIONS (US) <Tom.Terrian.ctr_at_dla.mil>
Date: Thu, 6 Apr 2017 17:09:44 +0000
Message-ID: <BN1P111MB0205216B5C3D976E3D0DF48B10D0_at_BN1P111MB020.NAMP111.PROD.OUTLOOK.COM> 





My scheduler jobs stopped running a month ago:



SQL> select JOB_NAME,  NEXT_RUN_DATE from dba_scheduler_jobs where rownum = 1;



JOB_NAME





NEXT_RUN_DATE





PURGE_LOG



10-MAR-17 03.00.00.100000 AM PST8PDT



Any idea why?



SQL> sho parameter job


NAME                                 TYPE        VALUE


------------------------------------ ----------- ------------------------------


job_queue_processes                  integer     1000





--



http://www.freelists.org/webpage/oracle-l
Received on Thu Apr 06 2017 - 19:09:44 CEST












Original text of this message