Re: DBMS_JOB

  • From: Connor McDonald <hamcdc@xxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 3 Mar 2005 23:59:52 +0000 (GMT)

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 :-)


--- Jared Still <jkstill@xxxxxxxxx> wrote:

> 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@xxxxxxxxx> wrote:
> > On Wed, 2 Mar 2005 23:32:03 +0000 (GMT), Connor McDonald
> > <hamcdc@xxxxxxxxxxx> 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
> > --
> > //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@xxxxxxxxx

"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 
--
//www.freelists.org/webpage/oracle-l

Other related posts: