为什么更改ExecutionLogDaysKept值不会反映在ReportServer数据库的ExecutionLogStorage表中？ [英] Why change in ExecutionLogDaysKept value doesn't reflect in ExecutionLogStorage table on ReportServer Database?

问题描述

您好，



之前：

有超过120天的数据





我尝试按如下方式更改ExecutionLogDaysKept的值：

  UPDATE  ConfigurationInfo  SET 值= '  90'  WHERE 名称= '  ExecutionLogDaysKept' 

然后我重新启动了所有与SQL相关的服务，并尝试检查ReportServer DB的ExecutionLogStorage表中的数据。



之后：

无变化

预计（数据较早，然后90天将被清除）



有人可以帮我吗？



我是否需要按照一些步骤自动清除ExecutionLogStorage表中的数据？

任何帮助将不胜感激。



谢谢，

Hitesh Varde，

软件工程师

解决方案

Hello,

Before:
There is data older then 120 days


I have tried changing value of ExecutionLogDaysKept as follows:

UPDATE ConfigurationInfo SET Value = '90' WHERE   Name = 'ExecutionLogDaysKept'

I then restarted all SQL related services and tried checking data in ExecutionLogStorage Table of ReportServer DB.

After:
No Change
Expected(Data Older then 90 days would be cleared)

can anyone please help me with it?

Do I need to follow some steps to clear data from ExecutionLogStorage Table automatically?
Any help would greatly be appreciated.

Thanks,
Hitesh Varde,
Software Engineer

解决方案

这篇关于为什么更改ExecutionLogDaysKept值不会反映在ReportServer数据库的ExecutionLogStorage表中？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！