• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 697
  • Last Modified:

ExecutionLog in reportserver

why in database REPORTSERVER,  i a table [ExecutionLog] , only save then history of the last 3 months and not before?
0
rauljimenez
Asked:
rauljimenez
  • 2
1 Solution
 
Daniel_PLDB Expert/ArchitectCommented:
You need to extend default 60 days time limit:
 
USE ReportServer
GO
UPDATE ConfigurationInfo
-- set 365 days limit
SET Value = '120'
WHERE Name = 'ExecutionLogDaysKept'

Open in new window


You can gather historical data somewhere else - read following:
http://sqlserverpedia.com/blog/sql-server-bloggers/querying-the-report-server-execution-log/
0
 
Daniel_PLDB Expert/ArchitectCommented:
Oh, mistake found, please ignore comment from above - it was from my code - it extends history to 120 days off course ;)
http://plataan.typepad.com/microsoftdynamics/2009/08/sql-2008-reporting-execution-log.html
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now