I need a stored procedure that scans a database for new records. The database holds the type, content, and recipient for e-mails and SMS messages. The SP needs to scan the database, determine whether e-mail or SMS, composes and send the message, then update the DB with send status. I believe there are sp's specifically for this (e.g. sp_send_dbmail)
I'd like to have this done in the Feb/March time frame. Attached is DB structure