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