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)
- 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' :-) - 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 - 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 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).
