SrcExitLoop="FALSE"
Src_InitialStartTime=`date +%s`
Src_StartTime=`date +%s`
Src_NUM_ALERTS=0
TOTAL_ALERTS=`expr <SOME WAIT THRESHOLD.e.g.50> / <SOME ALERT SECONDS.e.g 10>`


while [[ ${SrcExitLoop} == "FALSE" ]]
do

"Some Oracle Query"

Src_CurrentTime=`date +%s`
Src_WaitTime=`expr ${Src_CurrentTime} - ${Src_StartTime}`
Src_TotalTime=`expr ${Src_CurrentTime} - ${Src_InitialStartTime}`

if [[ ${Src_WaitTime} -gt <SOME ALERT SECONDS.e.g 10> ]]
 then
  if [[ ${Src_TotalTime} -gt <SOME WAIT THRESHOLD.e.g.50> ]]
   then
    echo "Reached Max Seconds"
  else
   Src_NUM_ALERTS=`expr ${Src_NUM_ALERTS} + 1`
   TotalTimeFormat=`printf ""%dh:%dm:%ds"\n" $((${Src_TotalTime}/3600)) $((${Src_TotalTime}%3600/60)) $((${Src_TotalTime}%60))`
   AlertSecondsFormat=`printf ""%dh:%dm:%ds"\n" $((${alert_seconds}/3600)) $((${alert_seconds}%3600/60)) $((${alert_seconds}%60))`
   errorSubject="ALERT ${Src_NUM_ALERTS}/${TOTAL_ALERTS} :- Process continues"
   errorText="EMAIL BODY"

   nohup sendAlertMail.ksh "$errorText" "$errorSubject" "$EMAIL_LIST" 2>&1 &

   #echo "${errorText}" | mailx -s "${errorSubject}" ${EMAIL_LIST}

  Src_StartTime=`date +%s`
 fi
else
  sleep <SOME VALUE.e.g.5>
fi

if [[ ${Src_TotalTime} -gt <SOME WAIT THRESHOLD.e.g.50> ]]
  then
    Src_NUM_ALERTS_1=`expr ${Src_NUM_ALERTS} + 1 `
    TotalTimeFormat=`printf ""%dh:%dm:%ds"\n" $((${Src_TotalTime}/3600)) $((${Src_TotalTime}%3600/60)) $((${Src_TotalTime}%60))`
    AlertSecondsFormat=`printf ""%dh:%dm:%ds"\n" $((${alert_seconds}/3600)) $((${alert_seconds}%3600/60)) $((${alert_seconds}%60))`
    errorSubject="ALERT ${Src_NUM_ALERTS_1}/${TOTAL_ALERTS} :- Process STOPPED"
    errorText="EMAIL BODY"
    
     nohup sendAlertMail.ksh "$errorText" "$errorSubject" "$EMAIL_LIST" 2>&1 &

     #echo "${errorText}" | mailx -s "${errorSubject}" ${EMAIL_LIST}

    SrcExitLoop="TRUE"
    exit 0
fi
done

#! /bin/ksh
echo "$1" | mailx -s "$2" "$3"