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.
Related Problem: PRB884265