Sending reminder e-mails at a given time every week in .NET

Question

0.00/5 (No votes)

See more:

Hello, what is the best way to send e-mail reminders at a given time in ASP.NET Core, once per week? It needs to happen every week, to users who made requests at least 7 days. Those requests are stored in the database hosted on Azure.

What I have tried:

So far I've came with idea of creating a web job on Azure, which checks database for unfinished requests older than 7 days, with cron scheduling when to send out reminders. Is there a better way to do it?

Posted 22-Dec-21 2:26am

Member 15341738

Updated 22-Dec-21 2:39am

Add a Solution

1 solution

Add a Solution

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

#realJSOP · Answer 1 · 2021-12-22T02:39:00

Solution 1

Don't do it in .Net - let the database do it.

Setup a job that sends the reminders every day at a specific time. Keep in mind that you'll probably need to setup a no-reply email account in order to use an SMTP server.

Don't forget to give the user an opportunity to opt-out of the notifications.

Posted 22-Dec-21 2:39am

#realJSOP

Comments

Member 15341738 23-Dec-21 4:36am

Unfortunately sending emails is not possible in Azure SQL Server, which we are using (as far as I know).

#realJSOP 23-Dec-21 8:15am

You could

0) When the user logs on to the web app, if a request has expired, force them to either finish it or cancel it before they can create a new one. (this doesn't require any additional crap running or database/CRON jobs). This is probably the way I'd prefer to do it, because it's what I call a "natural" event, as opposed to a "subsidized" event that is trigger by an outside source.

-OR-

1) Create a Windows service on the web server that checks for unfinished requests once per day and handles the email chores.

Sending reminder e-mails at a given time every week in .NET

1 solution

Solution 1

Add your solution here

Preview 0

Sending reminder e-mails at a given time every week in .NET

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us