I'm doing a queue system and I need that after 30 minutes that the user entered the queue, the system changes its status from true to false but without any request to the server, it does so directly in the database, Can you?
I'm doing a queue system and I need that after 30 minutes that the user entered the queue, the system changes its status from true to false but without any request to the server, it does so directly in the database, Can you?
The simplest thing, in my opinion, to build a JOB that runs every 30 minutes, which would verify a "Date of entry to the queue" if it exceeded 30 minutes in relation to GETDATE (), perform the UPDATE that you mention.
Greetings ..//