CRM Job Maintenance Logs in SQL Database

Question

We are managing our CRM 2013 (on-premise) maintenance jobs via the "CRM 2011 Job Editor" (downloadable from Codeplex here: https://crmjobeditor.codeplex.com/).

We have set a reindexing job to run daily, however we would like to double-check if the job might not run on certain days due to errors or whatnot.

Do you know if there are any written logs of the CRM maintenance jobs, if it's writing any history logs into the SQL database somewhere?

I see from CRM Trace when certain performance task is initiated, however keeping trace on at all time consumes a lot of disk space... just wondering if CRM by design writes any log history of maintenance plan into SQL database.

Answer 1

The System Job entity (schema name: asyncoperation) is where I'd start. That entity has a Job Type field and one of the values is Index Management. Check that entity's table.