(Asp.net ) reminder system to send notifications

Question

0.00/5 (No votes)

See more:

Hi,

Technologies : ASP.Net WebForms or MVC, WebAPI

I need to create "something" to send notifications, kind of reminders, for instance to remind a person his appointment with a doctor.
The dates to send the notifications are saved in a DB

The "something" has to scan the database looking for the notificacionts to be sent, let's every 10 minutes.

I use the word "something" cause I don't have any idea about how to do it by now.

Maybe to create a thread in the global.asax during the Application_start event.
Maybe there's a third party component, I don't know

Thanks in advance!!
pascualito

What I have tried:

nothing yet, starting to explore solutions

Posted 14-Feb-20 2:03am

Pascualito

Updated 14-Feb-20 3:28am

Add a Solution

3 solutions

Solution 2

Hi

I haven't read the first option yet, but I agree with you about the second solution. It's seems to be a very simple solution.

Thanks a lot Richard!!

Pascualito

Posted 14-Feb-20 3:25am

Pascualito

Solution 3

If you are using SQL Server, another option would be to utilize SQL Agent as well as Database Mail

How To Send Mail Using SQL Server: Part 1[^]

Posted 14-Feb-20 3:29am

MadMyche

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)

Richard Deeming · Accepted Answer · 2020-02-14T02:29:00

If it has to be in ASP.NET, there are various tools you can use to schedule background jobs:
How to run Background Tasks in ASP.NET - Scott Hanselman[^]

However, I would be inclined to create a small console application to scan the database and send the pending notifications, and then use the Windows Task Scheduler to schedule it to run every ten minutes.