Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: dbms_job - running jobs every 15 minutes

RE: dbms_job - running jobs every 15 minutes

From: Freeman Robert - IL <FREEMANR_at_tusc.com>
Date: Wed, 22 Jan 2003 08:54:47 -0800
Message-ID: <F001.00537854.20030122085447@fatcity.com>


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-----
Sent: Wednesday, January 22, 2003 9:49 AM To: Multiple recipients of list ORACLE-L

Robert,  

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-----
Sent: Wednesday, January 22, 2003 10:10 AM To: Multiple recipients of list ORACLE-L

Cron? How 1980's.... :-))  

RF

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Freeman Robert - IL
  INET: FREEMANR_at_tusc.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (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). Received on Wed Jan 22 2003 - 10:54:47 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US