Event Management - Delete Work Notes job is causing large table scans which sometime run for hours - Known Error

Event Management - Delete Work Notes job is causing large table scans which sometime run for hours Description The scheduled job Event Management - Delete Work Notes is causing large table scans, which sometime run for hours.

There is a GlideRecord call from this job to sys_journal_field table. This call may cause database servers to run very high on IO WAIT due to large table scans.

Steps to Reproduce

Use an instance with Event Management com.glideapp.itom.snac plugin active Use a large sys_journal_field table Run the job and collect the SQL from the database side. For large tables, SQL runs for minutes and sometimes hours. Workaround Add an index on sys_journal_field table on name, element_id fields in order to prevent a full table scan. Related Problem: PRB884265