956685 wrote:You don't, at least not natively in cron. Your script would have to count the number of times it's emailed you and do it's own limiting. You should probably consider a more robust monitoring solution like DB console in your database (assuming it's Oracle) or Nagios or ZenOss or any one of those sorts of products.
I have a shell script setup to check a database table (log) every 2 minutes. If it finds rows it emails me (via cronjob). However, I get flooded with emails. How can I set a limit to the number of email/alerts I get.