>
>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.