UPDATE ConfigurationInfo
SET Value = '365'
WHERE Name = 'ExecutionLogDaysKept'
Tuesday, May 22, 2012
SQL Reporting Services 2008 Execution Log History
In SQL Reporting Services 2008, you can set the Execution Log retention to keep more than the default 60 days by updating the ConfigurationInfo table inside the ReportServer database. Inside that table is a value labeled ExecutionLogDaysKept which can be updated to any value up to 2,147,483,647 , with 0 meaning that all history is kept indefinitely. You can update the value to keep 1 year's (365 days) worth of history with the script below.
Subscribe to:
Post Comments (Atom)
I tried to put together possible option
ReplyDeletehttp://www.avyuktasolutions.com/blog/sql-server-reporting-service-executionlog/
hope this help!
Alpesh Dhori | Software Professional