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

Re: DBMS_JOB

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Thu, 3 Mar 2005 08:54:31 +0000
Message-ID: <7765c8970503030054a1d3aa1@mail.gmail.com>


On Wed, 2 Mar 2005 23:32:03 +0000 (GMT), Connor McDonald <hamcdc_at_yahoo.co.uk> wrote:
> I've always been slow at putting together complex interval functions...so some other solutions I
> typically use are:

<snip good stuff>

I'm surprised no-one has suggested not using DBMS_JOB, but using some other scheduler (cron or the scheduled tasks applet perhaps). In my book DBMS_JOB doesn't really cut it (and of course its gone in 10g).

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 03 2005 - 03:58:24 CST

Original text of this message

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