Hi...
I have this sql script and i have spool this output to the name backup_status.log

START_TIM END_TIME STATUS
--------- --------- -----------------------
14-JUL-08 14-JUL-08 COMPLETED WITH ERRORS

How to use IF statement in order to cut and email the status if the status for that day backup is COMPLETED WITH ERRORS??

I dont want to trigger the email with COMPLETED status, only trigger the email when STATUS is COMPLETED WITH ERRORS...

I will cronjob the sql script to monitor my everyday backup