Pros and Cons of SQL Server Database Mail
Why would you build a table to log the emails into, then have another process come through and read the emails from the table in order to send them via database mail.

Why not just modify your application to send the emails directly via database mail.

Database mail uses SQL Service Broker under the covers to handle the email sending.  When you tell it to send an email it drops the email into a queue, then a background process comes through and grabs the email and actually sends it.  In your current design:


You drop the message into a table
A process reads the email
That process sends it to database mail
Database mail puts it into a queue
Database mail reads from the queue and sends the email


Why not remove steps 1, 2 and 3 from the process.