crontab的一些注意事项

crontab -e
*/2 * * * *  /home/vsopt/zxg/statistic_shell/VSOP_STATISTIC.sh

（测试的时候每两分钟执行一次）


#######################################
#Description:VSOP
#author:Zhao,XingGuo
#2011-03-14
######################################

source /home/vsopt/.bash_profile

ORA_USER="vsop"
ORA_PASSWORD="vsop"
ORA_SID="vsopt"

DBUSER=$ORA_USER
DBPASSWORD=$ORA_PASSWORD
SID=$ORA_SID

echo $SID;
echo "start...";
SQL_STATISTIC="PK_VSOP_STATISTIC_PRODUCT_LATN.P_VSOP_STATISTIC_PRODUCT_LATN"
sqlplus -s $DBUSER/$DBPASSWORD@$SID<<EOF
exec $SQL_STATISTIC('20110322','DddEFAULT');
QUIT;
EOF

echo "end...";