We are using the Index Maintenance of Ola Hallengren (https://ola.hallengren.com) solution for a couple of years now. While setting up some new SQL servers we are seeing some strange behaviour in the SQL Agent Job.
When an error is raised in the process of trying to ALTER and index or UPDATING a statistics object the job fails the job also fails. But i cannot see why the job failed in the log. I can see errors written in the CommandLog table which we log to with the @LogToTable = 'Y' set in the jobstep, but don't see why the job would fail.
Question: Does the job exit as failed when 1 or more errors have occured in the maintenance time? Or is something else wrong?
Thanks in advance