SQL数据库中的CRM作业维护日志 [英] CRM Job Maintenance Logs in SQL Database

问题描述

我们正在通过"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.

这篇关于SQL数据库中的CRM作业维护日志的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！