In the site that I assumed from a client, developed in ASP.Net with C #, there are registered employees with a defined admission date. The registry of these developers is in a SQL Server 2008 database table.
I needed to create something (maybe a task) that would check if there are users with 45 days from their date of admission. Possibly a SELECT query in the database. If it exists, an automated email is sent to the user (s) notifying them that they must complete a self-assessment.
How can I do this? Does ASP.Net have anything to do with this?