#!/bin/bash
# Chequear registros en Tabla y alertar al llegar al limite
CONTEO=`echo -e "set head off\nset pagesize 0\nSELECT COUNT(DATA) FROM APPREG.DATA WHERE DATA = TO_DATE(SYSDATE,'DD/MM/YY');" |  sqlplus -S "/ as sysdba" | awk '/^[ 0-9\.\t ]+$/ {print int($1)}'`
LIMITE=5
 
if [[ "$CONTEO" -ge "$LIMITE" ]]
then
    echo "CRITICAL - Hay $CONTEO registros";
    exit 2;
else
    echo "OK - Hay $CONTEO registros";
    exit 0;
fi