SQL数据库中的CRM作业维护日志

问题描述:

我们正在通过"CRM 2011作业编辑器"(可从Codeplex此处下载:

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.

您是否知道CRM维护作业的任何书面日志,是否将任何历史日志写入SQL数据库的某个地方?

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?

我从CRM Trace中看到何时启动了某些性能任务,但是始终保持跟踪状态会占用大量磁盘空间……只是想知道CRM是否设计使维护计划的任何日志历史记录都写入了SQL数据库中.>

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.

系统作业实体(方案名称:asyncoperation)是我开始的地方.该实体具有作业类型"字段,值之一是索引管理".检查该实体的表.

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.