The solutions are available to provide alerts when any job fails in SQL Server.
Is there any solution available to configure data level alerts, for example,
- If the data has not been updated in the USER tables for, say, 2 hours, we get an ALERT
- If there is any USER table, a specific column has an aggregate of more than 100% (which is not correct), then we get an alert.
- If any specific column should have no value (say greater than 10), then we get an alert.
We can create a table for these types of alerts and then run any SSIS or TSQL package every 15 minutes, and anything that does not match the reference value set for the alerts we receive via email.
Is aware of any solution developed for this type of need