>>
>>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.
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.