Re: adding counter

From: Mark D Powell <Mark.Powell2_at_hp.com>
Date: Thu, 29 Oct 2009 07:53:59 -0700 (PDT)
Message-ID: <195f953e-f3c6-46ca-a9dd-b5b416b2caa4_at_s31g2000yqs.googlegroups.com>

On Oct 28, 10:04 pm, orion <jack22..._at_gmail.com> wrote:
> Hi,
> I need some help.
> Shell script counter. i need to add condition to check if counter is
> more than 10 and longer than 3 hours? it runs every 5 mins. it only
> check count and send email right now.
> it runs in cron as below
> gregcount.ksh gregdb 10 > /tmp/gregcount.out 2> /tmp/gregcount.err
>
> if [ $# -ne 2 ]
> then echo "Usage: $0 DB MAX_ALLOWED "
> exit
> fi
> DB=$1
> MAX_ALLOWED=$2
> MAIL_LIST=bob
> CNT=`${ORACLE_HOME}/bin/sqlplus -s \/nolog << EOF | tail +1 2>/dev/
> null
> set pages 0
> set head off
> set feedback off
> set termout off
> set verify off
> set echo off
> connect system/${SYS_PWD}_at_${DB}
> select count(*) from greg.counter;
> EOF`
> # echo $CNT
>
> if [ $CNT -gt $MAX_ALLOWED ]
> then mailx -s "too many ( ${CNT} ) in $1 !! " $MAIL_LIST < /dev/null
> else
> echo "All is well !! "
> fi

Here are two links that should be of interest. The first calculates the seconds between to counters and the second has the C program source for a time difference calculator.

http://www.askdavetaylor.com/date_math_in_linux_shell_script.html

http://www.unixtutorial.org/2008/06/unix-scripting-time-and-date/

HTH -- Mark D Powell -- Received on Thu Oct 29 2009 - 09:53:59 CDT