Lead list work stalls on a database lock

Detailed solution

1. Step 1Use one approved test, or a read-only aggregate report. Record the exact time and affected scope before changing anything.
2. Step 2Pause competing list-maintenance jobs through the approved process, then have the database owner capture a read-only lock snapshot and identify the blocking transaction.
3. Step 3Compare the before-and-after result using the same filters and time window; retain the evidence and rollback if the result changes unexpectedly.