Clear Query Locks ETL Job
The Clear Query Locks ETL job can clear database locks held by non-ETL users, often caused by bad queries. The Clear Query Locks ETL job can be scheduled, run as needed, or added to a job orchestration. Running this job prior to ETL jobs that must run at a specific time or based on a trigger, prevents those jobs from being delayed or blocked by database locks.
To use this feature, schedule or run the Clear Query Locks job, or include it in a job orchestration.