automatic send email from sql server data base

Posted by Parthipan under ASP.NET on 12/28/2013 | Points: 10 | Views : 2696 | Status : [Member] | Replies : 3
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?




Responses

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

Up
0
Down
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

Posted by: Bageshkumarbagi on: 12/30/2013 [Member] Starter | Points: 25

Up
0
Down
hi,
http://go4answers.webhost4life.com/Example/automatic-e-mail-sql-server-34250.aspx
http://www.mssqltips.com/sqlservertip/1803/auto-alert-for-sql-agent-jobs-when-they-are-enabled-or-disabled/
http://msdn.microsoft.com/en-us/library/ms191439.aspx

Thanks,
Bagesh Kumar Singh
Mark as answer if you have been satisfied

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

Posted by: Bageshkumarbagi on: 12/31/2013 [Member] Starter | Points: 25

Up
0
Down
have you got your answer.

Thanks,
Bagesh Kumar Singh
Mark as answer if you have been satisfied

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

Login to post response