Re: scheduler jobs not running.
Date: Thu, 06 Apr 2017 17:11:58 +0000
Message-ID: <CAN6wuX2y8111nSrdyg_3tjk8UeDSq7Ohq+-s3BNba22cJRhLwg_at_mail.gmail.com>
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> wrote:
> My scheduler jobs stopped running a month ago:
[image: Kellyn Pot'Vin on about.me]
Kellyn Pot'Vin-Gorman
>
> 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
>
>
> --
<http://about.me/dbakevlar>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Apr 06 2017 - 19:11:58 CEST