We require a new application to be written (in C#.NET) which interacts with our database to determine whether conditions require a notification e-mail (using SQL Server Database Mail) to be sent to pre-selected users.
Please see the attached specification and prototype application for full details.