Re: Confusing CTXSYS issue

From: ddf <oratune_at_msn.com>
Date: Wed, 16 Sep 2009 10:13:28 -0700 (PDT)
Message-ID: <884bb49b-ed79-4f1c-ba62-2bef4ab82c66_at_d23g2000vbm.googlegroups.com>



On Sep 16, 11:50 am, macdba321 <macdba..._at_gmail.com> wrote:
> Interesting...
>
> select job_name, last_start_date, next_run_date from
> dba_scheduler_jobs;
>
> DR$IDX_RY_RESOURCE_META$J
> 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

Original text of this message