automatic send email from sql server data base

Posted by Parthipan under ASP.NET on 12/28/2013 | Points: 10 | Views : 4415 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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?

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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:- http://www.youtube.com/watch?v=3tC4hbFXHE8 http://www.howtogeek.com/howto/database/sending-automated-job-email-notifications-in-sql-server-with-smtp/ http://www.aspsnippets.com/Articles/Automated-Email-Notifications-using-SQL-Server-Job-Schedular.aspx For task scheduler: http://www.sevenforums.com/tutorials/12444-task-scheduler-create-new-task.html http://www.makeuseof.com/tag/how-to-automate-windows-programs-on-a-schedule/ Parthipan, if this helps please login to Mark As Answer. \| Alert Moderator

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:-
http://www.youtube.com/watch?v=3tC4hbFXHE8
http://www.howtogeek.com/howto/database/sending-automated-job-email-notifications-in-sql-server-with-smtp/
http://www.aspsnippets.com/Articles/Automated-Email-Notifications-using-SQL-Server-Job-Schedular.aspx

For task scheduler:
http://www.sevenforums.com/tutorials/12444-task-scheduler-create-new-task.html
http://www.makeuseof.com/tag/how-to-automate-windows-programs-on-a-schedule/

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

Latest Posts