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: Crontab - HA

Re: Crontab - HA

From: Madhu R. Vajrala <Vajrala.Madhusudana_at_mayo.edu>
Date: Tue, 14 Jun 2005 11:27:40 -0500
Message-Id: <1118766460.26061.40.camel@fedora.mayo.edu>


Thank You very much, probably this is the solution that i am looking for.

Great day,
Madhu

On Tue, 2005-06-14 at 08:42 -0700, Mark Bole wrote:
> Perhaps best to use DBMS_SCHEDULER if you are on 10g.
>
> A very good solution specifically for your situation (VCS) is here:
>
> http://www.vxideas.org/cron-edit
>
> This shell script is designed to be a resource in your VCS group. I
> used it for several years in a production cluster -- both a primary and
> a logical standby database, each with its own set of associated cron
> jobs, and this tool handled them both, whether running together on one
> node or separately on different nodes -- the correct cron jobs always
> ran exactly where they were supposed to, nowhere else. No need to
> clutter up your crontab entries themselves with some ugly if-then logic.
>
> Unfortunately there was one small bug in the script, which is fixed by
> commenting out one line in the script as shown here. I sent the fix to
> the author but never got a response. :-(
>
> add_entry() {
> # this next line was a bug, un-doing what remove_entry did
> # cp $before $after
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jun 14 2005 - 12:33:53 CDT

Original text of this message

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