Re: scheduler jobs not running.

  • From: "Kellyn Pot'Vin-Gorman" <dbakevlar@xxxxxxxxx>
  • To: Tom.Terrian.ctr@xxxxxxx, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 06 Apr 2017 17:11:58 +0000

What does the log say at the time of the failure?
On Thu, Apr 6, 2017 at 10:10 AM 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


--


[image: Kellyn Pot'Vin on about.me]

Kellyn Pot'Vin-Gorman
about.me/dbakevlar
  <http://about.me/dbakevlar>

Other related posts: