How to make automatic recording of records in the database
technically it depends on the database you are using. if the database supports it, you can set up a scheduled job to scan records and identify later services and send help by email.
if the database does not support scheduled tasks, then you can set up a client timer job to do the same.
The traditional approach to this is to schedule a job (there are too many ways [1] to do this for me to go into details without knowing the server operating system, the DBMS, and what control you should set or schedule programs on the server).
Your scheduled task will regularly check the database for records that have not been visited and then take appropriate action, such as emailing support.
[1] Just so that it doesn't go completely unanswered; some DBMS (for example, SQL Server) have built-in scheduling tools. To do this, you can start a Windows service on the server. If not, you might consider starting a Windows service on one of your own servers to access the website (a great way to shed bandwidth).
a source to share
Use a scheduler like this one found on rufus . You can program it to run, for example, every hour and make it do the job without human interaction.
I am a Java store myself and I used quartz . This is nice and useful if you can adjust to jruby .
I've never liked database or operating system solutions because you have no control over them and often run them in different environments.
a source to share