RE: [Non-DoD Source] Re: scheduler jobs not running.

  • From: "Terrian, Thomas J CTR DLA INFO OPERATIONS (US)" <Tom.Terrian.ctr@xxxxxxx>
  • To: "dbakevlar@xxxxxxxxx" <dbakevlar@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 6 Apr 2017 17:29:01 +0000

That is when the database was last bounced.  I looked in it to see if someone 
set some odd parameter but didn’t see anything.

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On ;
Behalf Of Kellyn Pot'Vin-Gorman
Sent: Thursday, April 06, 2017 1:12 PM
To: Terrian, Thomas J CTR DLA INFO OPERATIONS (US) <Tom.Terrian.ctr@xxxxxxx>; 
oracle-l@xxxxxxxxxxxxx
Subject: [Non-DoD Source] Re: scheduler jobs not running.

All active links contained in this email were disabled. Please verify the 
identity of the sender, and confirm the authenticity of all links contained 
within the message prior to copying and pasting the address to a Web browser. 


________________________________



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 < Caution-mailto: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
        
        --
        Caution-http://www.freelists.org/webpage/oracle-l ;< 
Caution-http://www.freelists.org/webpage/oracle-l ;> 
        
        
        

-- 

        
 
<Caution-http://d3mod6n032mdiz.cloudfront.net/thumb2/d/b/a/dbakevlar/dbakevlar-105x70.jpg>
 
         Kellyn Pot'Vin-Gorman
about.me/dbakevlar
        
 < Caution-http://about.me/dbakevlar ;>  
��i��0���zX���+��n��{�+i�^

Other related posts: