Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Send email queued in table

Author  Topic 

SamC
White Water Yakist

3467 Posts

Posted - 2009-07-23 : 09:28:45
A few years ago, we implemented an email facility in SQL 2000 which did a pretty good job reading emails from a table and sending them ala SMTP. I wasn't impressed with the environment that the batch job ran in. Hard to develop. Hard to debug. No visibility into error conditions.

Since then, SQL 2005 and 2008 have come along and we have the opportunity to revisit this implementation when we port it to a newer SQL release. I'm looking for any posts, articles, or suggestions that cover better, more supportable methods of buiding a scheduled task that will periodically read email from a table and send them ala SMTP.

Thanks.
   

- Advertisement -