BlackList Brranch - Pankaj - Asset

export ORACLE_BASE=/opt/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/client
export PATH=$PATH:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/jdbc/lib:/usr/ccs/lib:/usr/openwin/lib:/usr/dt/lib
export ORACLE_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export TNS_ADMIN=$ORACLE_HOME/network/admin

====================================================
Asset


#!/bin/bash

if [[ $# -eq 0 || $# -gt 1 ]]; then
echo "Pass report name as Argument"
exit 1
fi

WORKING_DIR=/home/jagag/AssetCPC
DATE=`date +%m%d%y_%H%M`
LOGFILE=$WORKING_DIR"/Logs/runAssetCPC.log"

MAIL_LIST=jgunapati@corelogic.com
CPCAssetRpt=$1.$DATE.xlsx

echo -e `date +%d' '%b' '%Y' '%H:%M:%S`" *** Starting the CPC - Asset Data Report ***" >> $LOGFILE

echo -e `date +%d' '%b' '%Y' '%H:%M:%S`" --- Cleaning up archive and logs Directories ---" >> $LOGFILE
find $WORKING_DIR"/Reports/"* -mtime +3 -exec rm -f {} \;
find $WORKING_DIR"/Logs/"* -mtime +3 -exec rm -f {} \;

echo -e `date +%d' '%b' '%Y' '%H:%M:%S`" --- Executing Java Process ---" >> $LOGFILE
/space/java/jdk1.5.0_20/bin/java -jar $WORKING_DIR/GenExcel.jar $1 >> $LOGFILE

if [ $? -ne 0 ]; then
echo -e `date +%d' '%b' '%Y' '%H:%M:%S`" *** Error in generating CPC - Asset Data Report ***" >> $LOGFILE
else
echo -e `date +%d' '%b' '%Y' '%H:%M:%S`" *** Finished executing the CPC - Asset Data Report ***" >> $LOGFILE
mv $WORKING_DIR/Reports/$1.xlsx $WORKING_DIR/Reports/$CPCAssetRpt
fi

REPORTCOUNT=`cat $WORKING_DIR"/Reports/"$CPCAssetRpt | wc -l`

if [ $REPORTCOUNT -gt 1 ]; then
( echo "Please find attached the CPC Asset Data generated on `date`"; uuencode `echo $WORKING_DIR"/Reports/"$CPCAssetRpt` $CPCAssetRpt ) | /usr/bin/mailx -r "pssprd@dorado.com" -s "SJC CPC Asset Data Report on `date`" $MAIL_LIST
fi

#Dating the Log File
cat $WORKING_DIR/Logs/runAssetCPC.log >> $WORKING_DIR/Logs/runAssetCPC.log.$DATE
rm $WORKING_DIR/Logs/runAssetCPC.log
exit