...
Scheduled-style mechanism
This group of approaches is based on periodic scanning of all saved pieces and determining the status of poline on this basis. A typical algorithm for such mechanism might look as shown on Figure 1.
Checking and updating the PO line status upon retrieving
PostgreSQLÂ Trigger Functions
Vert.X Periodic Timer
#_executing_periodic_and_delayed_actions
Interceptor-style mechanisms
Separate Scheduler Application
PostgreSQL cron-job
pg_cron
...