Schedule properties (Reports page)
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 doesn't indicate how many times the shared schedule is used within that single report. For example, suppose 20 different subscribers to the Company Sales report use the same shared schedule to trigger subscription processing. In this case, the Company Sales report appears 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.
- Select Reports.
You can also manage shared schedules from the Site Settings of the Reporting Services Web Portal.
Note
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 Editions and supported features of SQL Server 2022.
Options
Folder
Specifies the path of the report.
Report
Specifies the name of the report that uses the schedule.