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

  • From: "Terrian, Thomas J CTR DLA INFO OPERATIONS (US)" <Tom.Terrian.ctr@xxxxxxx>
  • To: "don@xxxxxxxxx" <don@xxxxxxxxx>, "wndolo@xxxxxxxxx" <wndolo@xxxxxxxxx>
  • Date: Thu, 6 Apr 2017 20:55:55 +0000

Excellent.  Thank you.

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On ;
Behalf Of Don Seiler
Sent: Thursday, April 06, 2017 1:32 PM
To: wndolo@xxxxxxxxx
Cc: Kellyn Pot'Vin <dbakevlar@xxxxxxxxx>; 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. 


________________________________



We had an issue previously due to a bug with scheduler windows not changing if 
job_queue_processes was set to 0 at the time the change was scheduled. DB 
resource manager also played a part in this.

The bug we believe we hit was 22071881, FYI. There are a few patches out for it.

Don.

On Thu, Apr 6, 2017 at 12:23 PM, Bill Ndolo <wndolo@xxxxxxxxx < 
Caution-mailto:wndolo@xxxxxxxxx ;> > wrote:


        If you have oracle tools like sql developer or TOAD configured, you can 
easily see where the job is broken.  
        And yes, share logs.

        On Thu, Apr 6, 2017 at 12:11 PM, Kellyn Pot'Vin-Gorman 
<dbakevlar@xxxxxxxxx < Caution-mailto:dbakevlar@xxxxxxxxx ;> > wrote:
        

                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 ;>  





-- 

Don Seiler
Caution-www.seiler.us < Caution-http://www.seiler.us ;> 

Other related posts: