KB413080: How to use scheduling to purge element caches in the MicroStrategy Intelligence Server 9.x/10.x

The following steps explain how to schedule the purging of element caches:
 

• Create a schedule if a schedule is not available for use. For more information on creating a schedule, refer to the following technical note:
  
• KB19593 (KB5303-8X-2889) How to create a time based schedule in the Strategy Intelligence Server 9.x/10.x
• Go to the menu item Administration > Scheduling > Schedule Administration Tasks, as shown below:
  

• In the Schedule Administration Tasks window, select a project for which the element caches will be purged, as illustrated below:
  

• In the 'Choose one of the following actions' field, choose "Purge Element Cache".
• Click on the check box for the schedule created in the Step #1.
• Click 'OK'.

Verify that DssElementCachePurge has been added to the Schedule Monitor, as indicated in the screen shot below:
 

 
Note that this will only purge element caches in the Strategy Intelligence Server. In order to purge element caches stored in Strategy Desktop memory, users must restart Strategy Desktop or go to My Preferences > Advanced > Purge Client caches.
Note:
In clustered environments, administrators should use the 'Cluster Option' to specify if element caches should be purged locally or across all nodes.
For Command Manager:
PURGE ELEMENT CACHING IN PROJECT "<project_name>";
For automated execution, prepare a Windows batch file to execute Command Manager with the element cache purge script.
 
General form:
 
cmdmgr -n Project_Source_Name -u Username -f Inputfile
Example:
 
cmdmgr -n "Project_Source_Name" -u Administrator -f C:\PurgeElementCache.scp -o C:\CommandManagerOutput.txt
This batch file may be scheduled using the Windows Scheduler.
 
The Command Manager script, Windows batch file and Windows schedule should be set up on each node of the cluster.
 
KB413080