Re: Confusing CTXSYS issue
Date: Wed, 16 Sep 2009 10:13:28 -0700 (PDT)
On Sep 16, 11:50 am, macdba321 <macdba..._at_gmail.com> wrote:
> select job_name, last_start_date, next_run_date from
> 24-JAN-09 12.00.00.107000 AM -05:00
> 26-MAR-12 09.46.40.000000 AM -05.00
> So does this mean that it is schedule, but to run next in 2012?
> Thanks again.
Yes. What does the repeat_interval column report? It should display the frequency and the interval to use. That value may need to be changed to get the job to run on a more frequent (and current) basis. You can use the DBMS_SCHEDULER.SET_ATTRIBUTE procedure to make such changes.
David Fitzjarrell Received on Wed Sep 16 2009 - 12:13:28 CDT