April 16, 2009 at 7:53 am
My requirement would be to send emails to managers & associated employee based on few business rules.
The subject & body are different for each business rules. So I was thinking about adding a new table in the db to store the subject & body and pull the subject & body while sending emails.
I'm using sp_send_dbmail from the stored procedure. I would like to see any best practices, table design practices if any.
Thank you all.
April 17, 2009 at 10:32 am
table design is purely based on the requirement.
Are there any other requirements around these emails? i.e if there is any change to the Body for a Line of Business do you want to update it or want to have version of the data!!
April 17, 2009 at 11:08 am
Here we do send quite a few emails. We have
Table1 - Emails, put in the actual email text. may have tokens embedded that are replaced at send time.
table2 - email recipients (who's getting a particular email), linked to table 1
as we send, we update table2 with date/time and status.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply