#!/bin/sh
#
#
#   generate daily report
#

ORACLE_HOME=/opt/app/oracle/product/10.2.0/db_1; export ORACLE_HOME
LD_LIBRARY_PATH=/opt/app/oracle/product/10.2.0/db_1/lib; export LD_LIBRARY_PATH
ORACLE_SID=ASHSTG01; export ORACLE_SID
ORACLE_BASE=/opt/app/oracle; export ORACLE_BASE
PATH=$ORACLE_HOME/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/oracle/bin:/usr/local/bin:.; export PATH

#RECEIVERS2="klewis@AllianceTime.com,shecht@AllianceTime.com,jcarton@AllianceTime.com,mweinstein@AllianceTime.com,ilehrman@AllianceTime.com,jkhan@AllianceTime.com,hpan@alliancetime.com"
#RECEIVERS2="omssupport@alliancetime.com,hpan@alliancetime.com"
RECEIVERS2="hpan@alliancetime.com"

#$ORACLE_HOME/bin/sqlplus -s hsww_report/hsww_report545<< EOF
$ORACLE_HOME/bin/sqlplus hsww_report/hsww_report545<< EOF
set echo on
SPOOL /tmp/product_syn.txt;
@/home/oracle/hp/report_syn_all.sql;
SPOOL OFF;
EXIT;
EOF
#
#execute daily_metrics_report_ttt(4);
#grep -v "PL/SQL" /tmp/report10.txt|grep -v "rows selected" > /tmp/report1.txt
# Step 3: send email out to distribution list.
#/bin/cat /home/oracle/hp/daily_header /tmp/combined_daily_metrics.txt /home/oracle/hp/daily_footer > /tmp/test_mail
#mail -s "image tag path" $RECEIVERS2 </tmp/report1.txt 
#
exit 0
