Sorry - I should have been more specific with "earlier versions" - I was referring to 8.0 and (if memory serves) one of the 8.1.x's. I was pondering whether this had crept into 9 (although I would doubt it)
Keep us posted on what happens :-) Cheers Connor --- "Freeman, Robert" <[EMAIL PROTECTED]> wrote: > See inline... > > Robert G. Freeman - Oracle8i OCP > Oracle DBA Technical Lead > CSX Midtier Database Administration > Author: Oracle9i New Features > Mastering Oracle8i > > Clark Griswold: Eddie, has anyone ever told you that > you're bad luck? > Cousin Eddie: Those were my mother's dying words. > But I guess if your > body's covered in third degree burns, and your > foot's caught in a bear > trap, you tend to start talkin' crazy. > > > > -----Original Message----- > Sent: Wednesday, June 12, 2002 8:03 AM > To: Multiple recipients of list ORACLE-L > > > Some comments... > > >> some earlier versions of the db had job bugs > where > >> the next date was not correctly calculated and > thus > >> stopped running - typically threw an ora-600 or > at > >> least a trace file in bdump (as opposed to udump) > > Is this true in 9i? If so, can you provide any bug > numbers > we can reference with Oracle? I can't seem to come > up with > any specific to 9i in Metalink. > > > >> - we're running about 50 jobs at various > frequencies > >> on 9013 and not experienced anything you've > described, > >> at which point you're probably saying 'gee > thanks' :-) > > Well, that may be one catch, we are currently on > 9011... we have plans to > move > to 9013, but have not yet for some.... *cough*... > very good reasons. Maybe > this is an issue with 9011. If I could identify the > bug then perhaps I can > get Oracle to backport an existing patch. > > > >> - see if the problem still occurs if you > explicitly > >> - set next date within the job itself, ie > 'procx;' > >> - becomes 'procx(next_date);' - this is not a > great > >> - workaround, but it does confirm if the next > date value > >> - is not being derived correctly by the scheduler > itself > > Tried that, no joy. It's really strange, some jobs > will run all the time, > others > run once, twice, three times maybe and then just > never run again. > > >> - is the interval simple ? the most common errors > for > >> job timings I've seen are typically dodgey > interval > >> strings or passing a date to the parms instead of > a > >> varchar2 > > Interval is something akin to "sysdate + 5/1440"... > doesn't seem to complex. > Like I said, this stuff worked fine in 8i, but in 9i > it runs a while and > dies. > > Thanks for your thoughts! > > RF > > > > hth > connor > > --- "Freeman, Robert" <[EMAIL PROTECTED]> > wrote: > > I've got a TAR open on it now, but slow movement. > > > > RF > > > > Robert G. Freeman - Oracle8i OCP > > Oracle DBA Technical Lead > > CSX Midtier Database Administration > > Author: Oracle9i New Features > > Mastering Oracle8i > > > > Clark Griswold: Eddie, has anyone ever told you > that > > you're bad luck? > > Cousin Eddie: Those were my mother's dying words. > > But I guess if your > > body's covered in third degree burns, and your > > foot's caught in a bear > > trap, you tend to start talkin' crazy. > > > > > > > > -----Original Message----- > > Sent: Monday, June 10, 2002 2:39 PM > > To: Multiple recipients of list ORACLE-L > > > > > > We had the same situation and then we use "cron" > > that never fails. Now, we > > don't trust dbms_job ... I had a TAR open on that, > > but can't access it now. > > > > Raj > > > ______________________________________________________ > > Rajendra Jamadagni MIS, ESPN Inc. > > Rajendra dot Jamadagni at ESPN dot com > > Any opinion expressed here is personal and doesn't > > reflect that of ESPN Inc. > > > > QOTD: Any clod can have facts, but having an > opinion > > is an art! > > > > > > -----Original Message----- > > Sent: Monday, June 10, 2002 2:13 PM > > To: Multiple recipients of list ORACLE-L > > > > > > Anyone run into any problems with the job > scheduler > > in 9iR1 not kicking > > off jobs when they are scheduled? > > > > We have a situation where a given job (runs every > 4 > > hours or so) will be > > kicked > > of successfully 2-3 times, and then on the 4th > time > > the scheduler does not > > kick > > it off, next_date is not incremented... it's like > > the job just gets lost in > > space...This same scheduled job ran fine in 8i. > > (this is an 8i to 9i > > migrated > > database) > > > > Any thoughts on this? > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: Freeman, Robert > > 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). > > ===== > Connor McDonald > http://www.oracledba.co.uk > http://www.oaktable.net > > "Some days you're the pigeon, some days you're the > statue" > > __________________________________________________ > Do You Yahoo!? > Everything you'll ever need on one web page > from News and Sport to Email and Music Charts > http://uk.my.yahoo.com > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: =?iso-8859-1?q?Connor=20McDonald?= > 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). > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Freeman, Robert > 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). ===== Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net "Some days you're the pigeon, some days you're the statue" __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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).