2
On the site I took over from a client, developed in ASP.Net with C#, there are registered employees with a defined admission date. The registration of these employees is in an SQL Server 2008 database table.
I needed to create something (maybe a task) that would check whether there are 45-day users since their date of admission. Possibly a SELECT query in the bank. If it exists, an automatic email is sent to(s) due to(s) user(s) warning that they must complete a self-assessment.
How can I do that? ASP.Net has something to that effect?
You can create a "Service" project on C# and install it on the server to run routines from time to time. Or simply place a scheduled task on the server to be executed every day at specific times, and within that software you send emails and queries in the database.
– NIZZOLA