Software Development Network>> SQL Server>> Command line/utilities to clear cache
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 itemEnd Sub
I think I mixed in C# and VB.Net, but hopefully you can get the idea.
Hi Daniel,
Command line/utilities to clear cache
Zoe Elmo
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.
AshishMalhotra
E.Herzog
Hi Daniel,
Do you have this script Or any idea if it can be found in any website
Thanks,
J Lim