Solved

ExecutionLog in reportserver

Posted on 2011-03-23
2
666 Views
Last Modified: 2012-05-11
why in database REPORTSERVER,  i a table [ExecutionLog] , only save then history of the last 3 months and not before?
0
Comment
Question by:rauljimenez
  • 2
2 Comments
 
LVL 14

Accepted Solution

by:
Daniel_PL earned 500 total points
ID: 35197591
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
 
LVL 14

Expert Comment

by:Daniel_PL
ID: 35197609
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: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question