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