Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: DBMS_JOB
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
>
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"
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Mar 03 2005 - 19:03:02 CST