Re: scheduler jobs not running.
Date: Thu, 6 Apr 2017 21:51:58 -0400
Message-Id: <FC423395-D242-4E54-AE27-BE028E3CF6E8_at_gmail.com>
Have you checked DBA_SCHEDULER_JOB_RUN_DETAILS
This displays log run details for all Scheduler jobs in the database.
Karth
Sent from my IPhone
> On Apr 6, 2017, at 1:09 PM, Terrian, Thomas J CTR DLA INFO OPERATIONS (US) <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
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Apr 07 2017 - 03:51:58 CEST