CODEWITHSUNDEEP
sqldynamics-crmcrmmaintenance-plan
ichachan
ichachan

Reputation: 667

CRM Job Maintenance Logs in SQL Database

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.

Upvotes: 0

Views: 1643

Answers (2)

Ainuddin Saharuddin
Ainuddin Saharuddin

Reputation: 1

can use this query

use mscrm_config


select operationtype,case operationtype
when 14 then 'Deletion Service'
when 15 then 'Indexing Management'
when 25 then 'Catalog Full Index for Organization'
when 30 then 'Reindex All'
when 32 then 'Cleanup Inactive Workflow Assemblies'
when 40 then 'Goal Rollup'
when 41 then 'Create Audit Partition'
when 42 then 'Check for MUI Updates'
when 46 then 'Refresh Entity Row Count'
when 47 then 'Refresh Sharing Count'
when 61 then 'Check FullText Index Column Status'
end operationtype,enabled,dateadd(hh,8,modifiedon) modifiedon,
dateadd(hh,8,lastruntime) lastruntime,dateadd(hh,8,nextruntime) nextruntime,
recurrencepattern,dateadd(hh,8,recurrencestarttime) recurrencestarttime,dateadd(hh,8,startedon) startedon,
executiontime,lastresultcode,lastresultdata,
maintenancewindowendtime,maintenancewindowstarttime,
state,isdeleted
from scalegrouporganizationmaintenancejobs with(nolock)
order by lastruntime desc

Upvotes: 0

Polshgiant
Polshgiant

Reputation: 3664

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.

Upvotes: 0

Related Questions