Command line/utilities to clear cache

Hi,Does Reporting services expose any command-line or utility tools to clear reports cache explicitly other than the caching configuration at certain interval?Thanks,Jet
[169 byte] By [JLim] at [2007-12-23]
# 1
There are no command line utilties to clear the cache. You could use rs.exe and write a simple script to call the Soap method FlushCache()
DanielReib at 2007-8-30 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...
# 2

Hi Daniel,

Do you have this script? Or any idea if it can be found in any website?

Thanks,
J Lim

JLim at 2007-8-30 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...
# 3

You can find information about scripting here:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsuiref/htm/cpu_rs_v1_5fxe.asp

You should also look at this:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_prog_soapapi_script_3249.asp

The flush cache method is here:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_ref_soapapi_service_ak_22i9.asp

You script will look something like this (not sure this is 100% correct)

Public Sub Main()
Dim items() As CatalogItem
items = rs.ListChildren("/", True)

Dim type as ItemTypeEnum
Dim item As CatalogItem
For Each item In items
type = rs.GetItemType(item)
if (type == ItemTypeEnum.Report || type == ItemTypeEnum.LinkedReport)
rs.FlushCache(item)
Next item
End Sub

I think I mixed in C# and VB.Net, but hopefully you can get the idea.

DanielReib at 2007-8-30 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...

SQL Server

Site Classified