Email scheduling in C# (ASP .NET)

Question

Hi want to send birthday emails to all employees which details are stored in database. I found Quartz .NET library but can't understand the code exactly. can anyone please give me some sample code.?

Is your database hosted with SQL Server? If so you can make a new job in sql and send the emails from inside the job code. — Stefan P., Dec 08 '10 at 13:24

score 2 · Accepted Answer · edited May 23 '17 at 09:58

2

This is the first time I heard about Quartz. It looks cool.

Found this stackoveflow thread How to use Quartz.net with ASP.NET

edited May 23 '17 at 09:58

Community

1
1

answered Dec 08 '10 at 13:20

Ives.me

2,359
18
24

score 1 · Answer 2 · edited May 23 '17 at 12:18

1

Further to Ives - answer:

What about from their website:

http://www.quartz-scheduler.org/docs/examples/index.html

This blog maybe of help as well..

http://blog.goyello.com/2009/09/21/how-to-use-quartz-net-in-pro-way/

Stack Overflow Question Sending Periodic Mail according to user's Setting in ASP.net?

edited May 23 '17 at 12:18

Community

1
1

answered Dec 08 '10 at 13:24

Aim Kai

2,934
1
22
34

score 1 · Answer 3 · answered Dec 08 '10 at 13:43

1

I guess this is something similar here.

answered Dec 08 '10 at 13:43

score 0 · Answer 4 · answered Dec 08 '10 at 13:49

You can code a small console application, a simple database with 1 table as you said which keeps dates,names and other details you need.

Simply select all rows which meets condition

Birthday == DateTime.Now

and mail them in a loop.

You can add this exe as a scheduled job with a few clicks and set it to run every day. It would also be a good practice for you.

score 0 · Answer 5 · answered Dec 08 '10 at 14:58

0

You can write a script file (possibly in VBScript as a VBS file) and schedule that script file in the Windows Task Scheduler (say every morning 8 AM) on the server level.

answered Dec 08 '10 at 14:58

ncakmak

4,014
5
20
17

Email scheduling in C# (ASP .NET)

5 Answers5