RE: RE: DBMS_JOB interval wierdness

Yes and yes. Unfortunately, I don't have the time to setup the workaround for the GATHER_SCHEMA_STATS bug. It'll hit a NO_DATA_FOUND after all objects have been analyzed.

I've setup some error trapping and left the job alone to see if it runs without the error. And if there's no error, will it submit at the proper interval or not. Of course it runs at 1 *AM* and not *PM*, like I had said, so I'll wait to see what happens tomorrow.

Thx!

Rich Jesse                           System/Database Administrator
Rich.Jesse_at_qtiworld.com              Quad/Tech International, Sussex, WI USA

> -----Original Message-----
> From: dgoulet_at_vicr.com [mailto:dgoulet_at_vicr.com]
> Sent: Tuesday, July 16, 2002 12:53 PM
> To: Jesse, Rich; Multiple recipients of list ORACLE-L
> Subject: Re:RE: DBMS_JOB interval wierdness
>
>
> Jesse,
>
> Is this 8.1.6? If so there's a bug filed against dbms_stats.
>
> Dick Goulet
>
> ____________________Reply Separator____________________
> Subject: RE: DBMS_JOB interval wierdness
> Author: "Jesse; Rich" <Rich.Jesse_at_qtiworld.com>
> Date: 7/16/2002 12:24 PM
>
> Nope. 1 PM just like it should, only every day instead of
> every week. I've
> tried it with the "7" in and out of the TRUNC with the same results.
>
> One other thing I just noticed is that the job returns an
> error each time it
> is run due to bug in DBMS_STATS. I'm rectifying that now
> with trapping and
> an error table, but I'm still confused as to why it would
> resub in a day
> instead of the interval.
>
> Thx!
>
> Rich Jesse System/Database Administrator
> Rich.Jesse_at_qtiworld.com Quad/Tech International,
> Sussex, WI USA
>
> > -----Original Message-----
> > From: dgoulet_at_vicr.com [mailto:dgoulet_at_vicr.com]
> > Sent: Tuesday, July 16, 2002 11:31 AM
> > To: Jesse, Rich; Multiple recipients of list ORACLE-L
> > Subject: Re:DBMS_JOB interval wierdness
> >
> >
> > Jesse,
> >
> > No joke, let me guess, 8am every day, right? Try
> > TRUNC(SYSDATE+7)+1/24
> > instead.
> >
> > Dick Goulet
> >
> > ____________________Reply Separator____________________
> > Subject: DBMS_JOB interval wierdness
> > Author: "Jesse; Rich" <Rich.Jesse_at_qtiworld.com>
> > Date: 7/16/2002 9:08 AM
> >
> > Hey all,
> >
> > I've got a job to gather stats on a schema of an 8.1.6.0.0
> > DB. The interval
> > of the DBMS_JOB is:
> >
> > TRUNC(SYSDATE)+7+1/24
> >
> > ...but it keeps resubmitting itself every day, instead of
> once a week.
> >
> > I *must* be brain dead or this cold's getting the best of me,
> > because I just
> > can't see what I'm missing.
> >
> > Anyone? Bueller? Bueller?
> >
> > Rich Jesse
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: Rich.Jesse_at_qtiworld.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).