Have you checked DBA_SCHEDULER_JOB_RUN_DETAILS
This displays log run details for all Scheduler jobs in the database.
Karth
Sent from my IPhone
On Apr 6, 2017, at 1:09 PM, Terrian, Thomas J CTR DLA INFO OPERATIONS (US)
<Tom.Terrian.ctr@xxxxxxx> wrote:
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
--
//www.freelists.org/webpage/oracle-l
