问题描述
您好,
之前:
有超过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表中?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!