Databases Reference
In-Depth Information
For the report we used earlier, we do know that the report uses stored credentials.
You can verify if SQL Server Agent is running in SSMS. If not, you can start it from
there or in the Control Panel by accessing Windows Services.
Hands-on exercise 4.13 - creating a cache
refresh plan by preloading the cache
We will create a cache refresh plan for the CustomersNW report (you may use one of
your report) we used in creating subscriptions as follows:
1. Open the Home page of Report Manager using its URL.
2.
Click on the report CustomersNW report on the contents of HOME .
3.
Click on Manage from the dropdown for this report.
4.
Click on the Cache Refresh Options tab on the left.
Presently there are no plans as shown here:
5.
Click on New Cache Refresh Plan '
6.
You will get a message as caching is not enabled for the report. If the item does
not have caching enabled, you will be prompted to enable caching.
 
Search WWH ::




Custom Search