...

  1. 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.

  2. Image RemovedImage Added

    Checking and updating the PO line status upon retrieving

    PostgreSQL Trigger Functions

    Vert.X Periodic Timer

    #_executing_periodic_and_delayed_actions

  3. Interceptor-style mechanisms

    Separate Scheduler Application

    PostgreSQL cron-job

    pg_cron

...