Re: scheduler jobs not running.

  • From: Karthikeyan Panchanathan <keyantech@xxxxxxxxx>
  • To: Tom.Terrian.ctr@xxxxxxx
  • Date: Thu, 6 Apr 2017 21:51:58 -0400

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

--
http://www.freelists.org/webpage/oracle-l


Other related posts: