search cancel

How to keep a minimum number of statistics/executions

book

Article ID: 213950

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

This article addresses how to keep a minimum number of statistics or executions (some customers refer to these as $stdlist, although this is not common Automic vocabulary) for Automic Automation tasks.

For example, a customer wants 10 years of data for a specific object that runs once annually.  They also want to show 10 months of data for an object that runs monthly.

Environment

Release : 12.3

Component : Utilities

Resolution

Statistics or Executions are removed via the reorg and unload utilities.  There are two options in the Reorg for which records should be flagged for deletion and then the unload will delete those.

"Reorg statistics older than x days, corresponds to the [today - x days]"
"Keep Last y Statistical records per object"

Please see the documentation here for more info on these settings in the reorg tool: https://docs.automic.com/documentation/webhelp/english/AA/12.3/DOCU/12.3/Automic%20Automation%20Guides/help.htm#Utilities/admin_AE_DB_Reorg.htm#link4

To keep the last 10 records per object, they will need to set the second to 10.  This can be done with the following steps:

Open the reorg gui (ucybdbreg.exe)
Putt the login information for the client number where statistical records should be kept
Double-click on the "Statistics" row
Be sure that "Keep last" checkbox is checked
Update the number to 10

PLEASE NOTE: This will start keeping the statistical records moving forward, if the records were already removed from the database, they cannot be retrieved within Automic.  They can only be retrieved via the Archive Browser, assuming that the archive is used.  For more information on the Archive Browser and archive, please see the documentation here: https://docs.automic.com/documentation/webhelp/english/AA/12.3/DOCU/12.3/Automic%20Automation%20Guides/help.htm#Utilities/admin_AboutArchiveBrowser.htm?TocPath=Reference%257CUtilities%257CAE%2520DB%2520Archive%257C_____1