Calling a stored procedure from trigger

Question

I have a requirement, where the user selects a date from the form and on that date a trigger should be fired that will update a table.
Is it feasible? If yes how can I accomplish it?

Answer 1

So I was wondering if I can create SQL Trigger that calls the stored procedure to update on that particular date

Do you mean a DML trigger on a database table like https://learn.microsoft.com/en-us/sql/relational-databases/triggers/dml-triggers?view=sql-server-ver15
Don't make much sense.

Better your ASP.NET backend execute the stored procedure directly passing the selected date as parameter.

Answer 2

Can you elaborate on your environment? You need some sort of a service to be running or you may want to use a SQL Server job.