adding counter

From: orion <jack22306_at_gmail.com>
Date: Wed, 28 Oct 2009 19:04:05 -0700 (PDT)
Message-ID: <743c9c20-acb6-4f23-b0e4-87d522d21d13_at_v30g2000yqm.googlegroups.com>

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 Received on Wed Oct 28 2009 - 21:04:05 CDT