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.

Upendra Bhushan

Use cron to manage to recurring task.
Check the file for conditions (there is not enough information in your post to determine the best way to do that).
If conditions warrant an alert use a mail client (mutt is a good choice) to send yourself an email.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.