automatic send email from sql server data base

Posted by Parthipan under ASP.NET on 12/28/2013 | Points: 10 | Views : 3883 | Status : [Member] | Replies : 1
I have sqlserver database. I have one data table with fromemailid, password, toemailid, subject, body, and time for sending the email.
for example: one email to correct emailid when the time 30.12.2013 11.30AM reached. This mail send automatically when that correct time reached. how to do this automatic email send?


Posted by: vishalneeraj-24503 on: 12/28/2013 [Member] [MVP] Platinum | Points: 25

Here,you can make stored procedure and inside that stored procedure,write your mail sending code. and make a windows application,call your stored procedure.

finally use windows task scheduler to send mail.In task scheduler,you can schedule date and time.

For sql server auto mail:-

For task scheduler:

Parthipan, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response