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

I would definitely look at SSIS. Hate to make a dogmatic statement, but anyone working in the SQL Server environment should know at least the basics of SSIS. It has a learning curve, but the benefits are well worth it