script

Below  is the script

===========================================================================================

usppodivximf00(usoponshximf00):/vol01/sites/provisioning/IG/46762> cat OBTM.sh
#!/bin/ksh
#*****************************************************************************************
#
# This Unix script is used for running OBTM
#
# Modification Log History
# ============================
# Date       By                CR/DF   Comments
# ---------- ----------------- ------- ---------------------------------------------------
# 08/28/2013
#*****************************************************************************************
#

#******************************************************************************************
# Environment properties
#******************************************************************************************
CR="46762"
ORACLE_HOME="/vol01/local/oracle/product/10.2.0";           export ORACLE_HOME
PATH=$PATH:.:$ORACLE_HOME/bin;                              export PATH
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib;          export LD_LIBRARY_PATH
BATCH_DIR="/vol01/sites/provisioning/IG/${CR}"
export ORACLE_BIN=$ORACLE_HOME/bin


#******************************************************************************************
# Mail properties
#******************************************************************************************
sendmailCmd="/usr/lib/sendmail -t -f [email protected]"
export sendmailCmd

eval `grep "^recipientlst" $BATCH_DIR/$CR.prop`
RecipientList=${recipientlst##*=}
export RecipientList

eval `grep "^Carboncopy" $BATCH_DIR/$CR.prop`
CC=${Carboncopy##*=}
export CC


#******************************************************************************************
# Load properties
#******************************************************************************************
eval `grep "^DBpassWord" $BATCH_DIR/$CR.prop`
DBPASS=${DBpassWord##*=}

eval `grep "^DBuser" $BATCH_DIR/$CR.prop`
DBUSER=${DBuser##*=}

eval `grep "^DBsid" $BATCH_DIR/$CR.prop`
DBSID=${DBsid##*=}

#******************************************************************************************
# Execute the OBTM validation query.
#******************************************************************************************
./count.sh > error.out

ObtmCountLog=$BATCH_DIR/obtmCount.txt
OBTMCount="`cat ${ObtmCountLog}`"
FindError=$BATCH_DIR/error.out
FindingError="`cat ${FindError}`"
#echo "No. of OBTM records processed for the day : " ${OBTMCount}

tt=$(grep -c "ORA-" $BATCH_DIR/error.out)
if [ ${tt} -ne "0" ]
then
#******************************************************************************************
# Email to the sustain team
#******************************************************************************************
echo "OBTM Report error occured at `date '+DATE: %m/%d/%y TIME:%H:%M:%S'`"
#TO="To: `cat ${RecipientList}`"
#CC="CC: `cat ${CC}`"
TO="To: [email protected]"
CC="CC: [email protected]"
Subject="Subject: OBTM Report did not process on `date '+DATE: %m/%d/%y TIME:%H:%M:%S'`"
Message="OBTM Report did not process properly on `date '+DATE: %m/%d/%y TIME:%H:%M:%S'` please run it manually"
MAIL="${TO}\n${CC}\n${Subject}\n\n${Message}\n"
(echo ${MAIL};) | ${sendmailCmd}

elif [ ${OBTMCount} -eq "0" ]

then
echo "OBTM record count processed for the day is  :" $OBTMCount
    echo "OBTM query errored"
#TO="To: `cat ${RecipientList}`"
#CC="CC: `cat ${CC}`"
TO="To: [email protected]"
#CC="CC: [email protected]"
Subject="Subject: OBTM Report did not process on `date '+DATE: %m/%d/%y TIME:%H:%M:%S'`"
Message="OBTM Report did not process properly on `date '+DATE: %m/%d/%y TIME:%H:%M:%S'` please run it manually"

MAIL="${TO}\n${CC}\n${Subject}\n\n${Message}\n"
(echo ${MAIL};) | ${sendmailCmd}

else

cat /dev/null>obtmCount.txt
echo "Processing the OBTM report for the day...."
echo "Executing scripts ${CR}.sql"
$ORACLE_BIN/sqlplus ${DBUSER}@${DBSID}/${DBPASS} << EOF
@${BATCH_DIR}/${CR}.sql
EOF
echo "OBTM Report Completed at `date '+DATE: %m/%d/%y TIME:%H:%M:%S'`"


#******************************************************************************************
# Email to the customer
#******************************************************************************************

FILENAME=${BATCH_DIR}/OBTM_Report.csv
ATTACH_NAME=OBTM_Report.csv


#TO="To: `cat ${RecipientList}`"
#CC="CC: `cat ${CC}`"
TO1="To: [email protected]"
#CC1="CC: [email protected]"
Subject1="Subject: OBTM Report for `date '+DATE: %m/%d/%y TIME:%H:%M:%S'`"
Message1="OBTM Report for `date '+DATE: %m/%d/%y TIME:%H:%M:%S'`"
MAIL1="${TO1}\n${CC1}\n${Subject1}\n\n${Message1}\n"
(echo ${MAIL1};uuencode ${FILENAME} ${ATTACH_NAME}) | ${sendmailCmd}
#(echo ${MAIL1};uuencode ${ATTACH_NAME}) | ${sendmailCmd}
exit

fi


=====================================================