aidacra
(Nathan your friendly neighborhood Support Engineer)
5
The SQL job is blocking a SQL object that the task agent processing needs. Don’t use the built-in SQL Wizard options for index/stats maintenance as it is overkill. I’d recommend implementing the Ola Hallengren index maintenance script as it only maintains those indexes/stats when it is needed based on the thresholds you set.