#!/bin/ksh

for SID in OM DW
	do
	export ORACLE_SID=${SID}
	/u01/app/oracle/product/11.2.0/dbhome_1/bin/sqlplus -s '/ as sysdba' @/home/oracle/scripts/Daily_Table_Report.sql
	mail -s " Daily Table Report"
	bill_robinson@bmc.com < /home/oracle/scripts/Daily_Table_Report.out
done