omscripts_db_14_autosendrep.sh

 vi /oracle/u02/omscripts/14_autosendrep.sh

#!/bin/bash

if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi

# User specific environment and startup programs

MAILLIST='cc.vbhsieh@gmail.com'

. ~/.bash_profile



/oracle/u02/omscripts/10_autorep.sh
DAY_1=`date -d "1 day ago" +%Y_%m_%d`

#TMPFILE2="/tmp/sp_${ORACLE_SID}_${DAY_1}.lst"
TMPFILE="/tmp/sp_${ORACLE_SID}_${DAY_1}.txt"
mv ${TMPFILE2} ${TMPFILE}


#echo "${ORACLE_SID} DB StackPack Report ${DAY_1} " | mail -s "${ORACLE_SID} DB StackPack Report ${DAY_1} " -a ${TMPFILE} -c $MAILLIST $TPMMAIL

/omscripts/sendEmail/sendEmail.pl -f "ORCL_DB@MikeLab.test" -s 192.168.44.20:25 -u "[TOP SQL]_[ORCL] DB StackPack Report ${DAY_1} " -m "ORCL DB StackPack Report ${DAY_1} " -t "$MAILLIST"  -a "$TMPFILE"