Jaa


Verifying a Report Run

To view information about the status of report processing, you can use log files or refer to status information that is displayed with the report in Report Manager.

Sources of Report Execution Data

The report execution logs provide comprehensive information about report execution, including the name of the report, the name of the user who ran the report, report execution time, and the delivery extension used to distribute the report. To view and analyze this data, you can copy the report execution log into database tables that are easy to query and report on.

Log files contain many entries about report execution and other server activity. Because log files contain so much data, you may want to use Report Manager if you only want to verify when the report last ran. If you require additional information, you must view the log files.

Note

Report Manager does not show the processing times of reports that run on demand.

The following table describes how to view the processing date and time for various types of reports.

For this type of report Date and time information is located here To view the information, do the following

A report that runs as a report snapshot.

On the Contents page. For more information, see Contents Page (Report Manager).

  1. Locate the folder that contains the report.
  2. Set the folder in Details view.
  3. Note the date and time in the When Run column.

A snapshot in report history.

On the History Properties page. For more information, see History Properties Page (Report Manager).

  1. Open the report.
  2. Click the Properties page.
  3. Click the History tab.
  4. Note the date and time in the When Run column.

A cached report.

In the schedule used to create and refresh the cached report.

  1. Open the report.
  2. Click the Properties page.
  3. Click the Execution tab.
  4. Open the schedule.

See Also

Concepts

Reporting Services Log Files
Report Manager

Other Resources

Managing Report Processing

Help and Information

Getting SQL Server 2005 Assistance