how to display this.....

Shell Programming and Scripting
1

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 :b:

2

Actually it depends on your backup script structure.

You can use "grep" to parse log file, and in case of match send email.