Purpose

This job limit the time of request being in status NEW or APPROVED. It changes status of person to merge requests to EXPIRED after configured period of it existance.

Job logic

1. Job starts once in 24 hours by default (configured parameter MERGE_REQUEST_SCHEDULE).

2. After starting it gets value from global parameter MERGE_REQUEST_EXPIRATION.

3. Select all entries from il.merge_requests with status=NEW or APPROVED:

   1. If inserted_at >= current_datetime() - MERGE_REQUEST_EXPIRATION. Then skip the record

   2. If inserted_at < current_datetime() - MERGE_REQUEST_EXPIRATION. Then update entry:

      1. set status = EXPIRED

      2. set updated_at = current_datetime()

      3. set updated_by = system_user()