Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Aug 08, 2012 06:07 PM by ramiramilu
Aug 08, 2012 01:29 AM|LINK
I have very complex requirement in one of the asp.net application . user defines the rules dynamically in asp.net page. and saves the Rule defnition into database.
I need to store the values in to datatbase when the above rules satisfy i need to send recurrence email.
can some body advise me how can i implement how should be the table design
Aug 08, 2012 04:42 AM|LINK
do you want send these automically or by hitting some button on front end
if you want to send mail using db automatically use sql agent mail functionality
Aug 08, 2012 06:07 PM|LINK
i dont think storing those rule values in database is a problem...but if wanted to send emails on completion of these rules then write some triggers in sql which willsend email form sql environment, or else you can write a simple windows service or schedule
an exe in task scheduler to send email on periodic basis....
send email in sql - http://blog.netnerds.net/2008/02/create-a-basic-sql-server-2005-trigger-to-send-e-mail-alerts/
windows service - http://www.intstrings.com/ramivemula/articles/sending-automated-emails-asynchronously-using-a-c-windows-service-in-conjunction-with-database-email-records-part-i/