>
>What's the best way to do that?
If you're using SharePoint, you can set up SSRS data alerts to do what you described.
For non-SharePoint environments, I've had clients where we set up SSIS jobs running under SQL Server Agent to check every X minutes for certain conditions - and if so, fire off an email.