How to schedule my stored procedure to run when there is an update in data in SQL without using the sql server agent?

Question

I am wondering whether is it possible to schedule my stored procedure to run without using the SQL Server Agent (as I don't have access), I would like it to run when there is new data ingested (I have an upload date column in the data, not sure can we use that to make the update when there is a change in date from the previous data).

Answer 1

You can create a TRIGGER. It allows you to execute custom code when data is changed (an after trigger) or instead CURD operations (instead trigger).

In your case, you my need AFTER INSERT, UPDATE, DELETE trigger as you need to apply logic when data is modified.