Sheduled emails in particular days later

Question

0.00/5 (No votes)

See more:

Dear Friend,
I have some problem when implementing code.I have an idea about that "how to send email" but no idea about "how to send email in particular days or how to sheduled emails".
For example :-if i am registered any website then if i am not used this website then automatically send notification emails particular 15 days later.I cant get an idea how to do so would you like to suggest me anything idea or information.

Thanks in advanced !!

Posted 1-Jul-13 2:34am

Member 8089110

Add a Solution

Comments

Thanks7872 1-Jul-13 8:37am

Which is the database?

Member 8089110 1-Jul-13 8:55am

Microsoft Sql Server 2008

ZurdoDev 1-Jul-13 8:42am

The best way, in my opinion, is a windows service.

Member 8089110 1-Jul-13 8:56am

i want to program by using asp.net,c#,linq,sql server 2008

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Amol_27101982, India · Answer 1 · 2013-07-01T04:56:00

Following 3 steps will get your job done:
1. Create a table in the database (say Email) and insert all the information related the email like subject, body, From, To etc. along with the date on which the email is to be sent (EmailSendDate).
2. Write a SP which will read above (Email) table and send email if current date is equal to the EmailSendDate.
3. Create a Job in the SQL server which will run every day (or the way you want), and call above SP in that job.

Hope this will help you.

~Amol

Thanks7872 · Answer 2 · 2013-07-01T06:20:00

The best way i think would be to use SQL Server Job. You can use that on predefined time interval as you want. For reference you can refer to below links.

A scheduler GUI for SQL Server Agent[^]

Manage SQL Server Agent Jobs using C#[^]

Schedule a Job[^]

How to: Schedule a Job (SQL Server Management Studio)[^]

[Important]:

sp_send_dbmail[^]

Regards.. :laugh:

Sheduled emails in particular days later

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0