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