RE: [Non-DoD Source] Re: scheduler jobs not running.
Date: Thu, 6 Apr 2017 17:53:49 +0000
Message-ID: <BN1P111MB020DF5CC5267C06F8E683FCB10D0_at_BN1P111MB020.NAMP111.PROD.OUTLOOK.COM>
It/they are not broken. They are scheduled to run but that date has come and gone...
-----Original Message-----
From: Bill Ndolo [mailto:wndolo_at_gmail.com]
Sent: Thursday, April 06, 2017 1:23 PM
To: Kellyn Pot'Vin <dbakevlar_at_gmail.com>
Cc: Terrian, Thomas J CTR DLA INFO OPERATIONS (US) <Tom.Terrian.ctr_at_dla.mil>; oracle-l_at_freelists.org
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.
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_at_gmail.com < Caution-mailto:dbakevlar_at_gmail.com > > 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_at_dla.mil < Caution-mailto:Tom.Terrian.ctr_at_dla.mil > > 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É^ Received on Thu Apr 06 2017 - 19:53:49 CEST