We have an alert that searches our databases for unknown/missing columns or tables. The search runs on an hourly basis, and sends an email if the condition is triggered. The issue we're running into is sometimes we don't have an opportunity to fix the missing column/table before the next hour goes by and the alert gets triggered again--leading to multiple emails for the same issue. We want to basically stop duplicate emails/duplicate triggers. I have read about throttling and that does not seem to be the fix we're looking for. In SQL terms, we'd be wanting an 'if/else' statement... if this missing column/table has already sent an email, don't send again. else, send. any thoughts would be appreciated!
