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

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.

1. Use an instance with Event Management com.glideapp.itom.snac plugin active
2. Use a large sys_journal_field table
3. Run the job and collect the SQL from the database side. For large tables, SQL runs for minutes and sometimes hours.