Re: Setting CRONTAB job to run every 60 seconds

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 12 Jan 2001 20:20:47 +0100
Message-ID: <93nm1q$atl0q$5@ID-62141.news.dfncis.de>

0-59 * * * * /usr/bin/ksh "(export
ORACLE_SID=icoms; . /export/home/
dmirror/.profile ; sqlplus ne_icoms/ne_icoms @/export/home/dmirror/admin/olrstat
us 1> /dev/null 2> /dev/null)"

However, this very much looks like a bad idea. Why can't you accomplish this by means of triggers. I say this because I inherited a similar system, and this procedure is a true disaster.

Hth,

Sybrand Bakker, Oracle DBA

<newopt_at_my-deja.com> wrote in message news:93ngno$okm$1_at_nnrp1.deja.com...
> I have a CRONTAB jub set to run every 10 minutes. Can someone tell me
> haow to set it up to run every 60 seconds.
>
> Here's what I have now:
> 0,10,20,30,40,50 * * * * /usr/bin/ksh "(export
> ORACLE_SID=icoms; . /export/home/
> dmirror/.profile ; sqlplus ne_icoms/ne_icoms
> @/export/home/dmirror/admin/olrstat
> us 1> /dev/null 2> /dev/null)"
>
> Thanks in advance!
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Fri Jan 12 2001 - 13:20:47 CST