I am triying to write a shell script which do the following steps:
1)Check the status of File (ie:Rejected,Processed and Processed_with_errors) from Database(i am using TOAD tool).
2)If the file is rejected ,then the script should immediatly send a MAIL ALERT to me.
3)If the file is processed_with_errors with mare then 15% rejections Then also should sent a MAIL ALert.
4)the script should rerun after every 15 minutes.
I need help.Please share your ideas.