To generate an email if more than 10 archives are generated in an Hour
SDATE=`date +”%d%b%y %H:%M”`; sqlplus -s ‘/ as sysdba’ @/home/oracle/COOL/archcounthr.sql > /home/oracle/COOL/archcounthr.log; cnt=`cat /home/oracle/COOL/archcounthr.log` if [ $cnt -gt 10 ] then echo “$cnt Archives generated in QTYDB at $SDATE” | mailx…
Read More