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: Connor McDonald <hamcdc_at_yahoo.co.uk>
Date: Thu, 3 Mar 2005 23:59:52 +0000 (GMT)
Message-ID: <20050303235952.53718.qmail@web86902.mail.ukl.yahoo.com>


Question of cash I suppose... For a large customer migrating from a mainframe to Oracle/Unix we purchased Autosys - very nice tool for scheduling with all the bits and pieces you would expect (allowable run times, dependencies, success/failure trees etc etc)...

But it wasn't free :-)

> You mean like 'at' on Windows?
>
> I mention this as I know you do windows. :)
>
> 'at' is anything if not unreliable.
>
> It has broken on a number of machines here, and no one can
> ever seem to determine why.
>
> I've been forced ( *forced* mind you) to resort to a Perl version of
> cron on Windows boxes where I want to reliable run external jobs.
>
> As for database jobs, DBMS_JOB has served me quite well. Not
> as robust as it could be, but it is easy to use, and on Windows
> platforms, saves me from setting up an external scheduler.
>
> A working one, that is.
>
> Jared
>
>
>
> On Thu, 3 Mar 2005 08:54:31 +0000, Niall Litchfield
> <niall.litchfield_at_gmail.com> wrote:
> > 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
> >
>
>
> --
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
>



Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions" Co-author: "Oracle Insight - Tales of the OakTable"

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com

"GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day"




Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 03 2005 - 19:03:02 CST

Original text of this message

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