I use SQL Server agent notifications a lot for notifying of failed jobs. Usually, jobs run every hour so I don't mind getting a few emails if the job fails.
However, I want to run a job every minute now and leave it running. I really don't want to get 100s of emails if it fails for a few hours.
Can I set a limit on the number of emails SQL Server agent will send for a job?