Clear OAC cache automatically

One of the requirements that customers have is how to clear OAC cache automatically.

We can do that using the repository and an agent in OAC.

First step: Create the connection pool in repository (Link to download)

Second step: Create an Analysis in OAC classic using the Create Direct Database Query.

Step 3: Use the connection pool that we created before and the command “call SAPurgeAllCache();”

If you run the analysis you should see this:

Step 4: Last but not least, create an agent to run this analysis. You can define a daily agent to run as often as you need.

If you have any doubt, please let me know.