LOL..... You are right about the job_scheduler in early
9i.....
Had
all sorts of problems when I first started moving stuff to
9.0.1
and 9.0.2 and Oracle was no help figuring out what the
problem was.
I use
cron all the time, but I love the job scheduler for things
like
starting parallel PL/SQL threads, etc.... It's just so easy!
;-)
Hey, I
*LIKE* retro, listen to the 80's station all the time!
RF
Robert G. Freeman
Technical Management
Consultant
TUSC - The Oracle Experts www.tusc.com
904.708.5076 Cell (it's
everywhere that I am!)
Author of several books you can find on
Amazon.com!
-----Original Message-----
From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 22, 2003 9:49 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: dbms_job - running jobs every 15 minutesRobert,I have solid reasons not to trust dbms_job ... it didn't work reliably in 901x. Call me retro ... but "cron" rocks ...8:)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-----
From: Freeman Robert - IL [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 22, 2003 10:10 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: dbms_job - running jobs every 15 minutesCron? How 1980's.... :-))RF