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]
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
Connor,
In our case the intervals were 5AM, 6AM and 12PM ... and it still didn't
work. Perfstat was the biggest problem, I used to run it at 15 min
intervals, and it would work for an hour or two and die unexpectedly without
any message or trace file.
Raj
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
Nope, they never show up there, so it appears the scheduler, for some
reason, just decides
to stop running them.
RF
Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
Author: Oracle9i New Features
Mastering Oracle8i
Clark
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?
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
Dick,
Thanks, and yes I understand both, but we had really bad luck with dbms_job
which would stop working without any errors. OWS was unable to give a quick
fix, and eventually it turned out that one of the parameters (I think
job_queue_processes) was getting reset or something like that. We
Just out of curiosity, are the jobs showing up in dba_jobs_running? I'm
wondering if they ever report back as having completed.
Brian
-Original Message-
Robert
Sent: Monday, June 10, 2002 1:13 PM
To: Multiple recipients of list ORACLE-L
Anyone run into any problems with the job