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 [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > 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" <[EMAIL PROTECTED]> > 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 > [EMAIL PROTECTED] Quad/Tech International, > Sussex, WI USA > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > > 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" <[EMAIL PROTECTED]> > > 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
