Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Verifying a Report Run

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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.

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 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 Snapshot Options 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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft