Slow Quick View on job query on certain jobs

Document ID : KB000014820
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

Only on certain jobs, Quickview is very slow in returning a response back.

Question:

Quick View ok overall - but this one job - it takes 1-5 minutes for the results to return in Quick View. 

ECLI it comes back in seconds. 

We want to know why this is happening, stop it from happening, and prevent it from happening again. 

Answer:

The problem was that these jobs had over 10,000 job runs in its history.  DBMaint was not running and caused the high number of job runs.  Run DBMaint manually to help.