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

Good ideas.
Thank you, Kevin.
I've avoided SSIS and Sharepoint, but with the cold weather coming, those will be good hibernation projects.