Trigger for immovable system

Asked

Viewed 31 times

-5

Staff I am developing a property system and I need every five minutes the bank to read the property information, process and decrypt the information, send a processing confirmation and discard the information. I’m thinking of doing some Rigger, but I don’t know how to release her every five minutes, can anyone give me a light? (Sorry for the lack of technicality, I’m still getting started)

database trigger

  • You can use SQL Server Job.

1 answer

1


As you are thinking of executing an action in the bank from time to time, I see that the best option is to use "Events"

Create event teste //bome
On schedule
Every 1 week //aqui é o intervalo
Do
NomeDaTrigger;

With this event you create field, delete, perform procedures and triggers, of predefined times and times.

Browser other questions tagged database trigger

You are not signed in. Login or sign up in order to post.