Backlog of jobs in sys_trigger with State: Ready that are not picked up to be processed though there are available scheduler workers


In New York release, if you note that there is a buildup of jobs in the sys_trigger table which are past the datetime in the next_action field and are not picked up for processing, you may be affected by this PRB. 

Some of the symptoms include:

Steps to Reproduce

  1. Access <instance> and filter for the following:
    • Next action at or before Today
    • State is Ready
    • Trigger type is not On Demand
  2. There will be a large number of records (>100,000). 
  3. Access <instance> and review the "Background Scheduler" section, refresh a few times and note that there are available scheduler workers with "Current job: idle"



As a workaround, please create a table index (composite) as follows:

Table: Schedule Item [sys_trigger]

Fields (Labels): Priority,Next action

Fields (name): priority,next_action

Related Problem: PRB1373305