Use the Reporting Services schedule properties page in SQL Server Management Studio to view a list of all reports that use the specific shared schedule. Schedules can be used to refresh report snapshots, generate report history, trigger a subscription, or expire a cached copy of the report. To find out how the schedule is used, view the property and subscription information of the report.
Although this page shows each report that uses the shared schedule, it does not indicate how many times the shared schedule is used within that single report. For example, suppose 20 different subscribers to the Company Sales report all use the same shared schedule to trigger subscription processing. In this case, the Company Sales report will only appear once in this list, even though the report has 20 references to the shared schedule.
To open the schedule properties page:
- Start SQL Server Management Studio.
- Connect to a report server.
- Open the Shared Schedules folder.
- Right-click a shared schedule, select Properties.
You can also manage shared schedules from the Site Settings of the Reporting Services Web Portal.
This feature is not available in every edition of SQL Server. For a list of features that are supported by the editions of SQL Server, see Features Supported by the edition of SQL Server 2016.
Specifies the path of the report.
Specifies the name of the report that uses the schedule.