try adding something like this to you shell script....

if [ $? -ne 0 ]
then
cat ${LOG_FILE} | mailx -s "Errors while processing " ${DBA}
else
echo "Everything's cool..." | mailx -s "Backup finished
sucessfully " ${DBA}
fi

Good luck!

Krishnan, Manjula wrote:

>I have a cron job that performs a backup of the database every night. It mails the logfile to me at the end of the job. but, if it fails I do not get a notification. Is there anyway I can get notification of failure?
>
>Thanks,
>
>Manjula Krishnan
>Database Administrator
>
>
>--------
>Get today's cartoon: http://www.LazyDBA.com
>Please don't reply to RTFM questions
>Oracle documentation is here: http://tahiti.oracle.com
>To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] using this list you agree to these terms:http://www.lazydba.com/legal.html
>
>
>
>

Oracle LazyDBA home page