Purging Static Data

Besides the processes running in the Redwood suite of products, there are also different types of static data that should be maintained to keep a healthy, fast and stable environment. This topic discusses such data.

Redwood recommends running the housekeeping processes described in this topic on a daily basis, either individually or in a Chain such as the following.

Cleared Events

Keeping all cleared events will eventually fill up the event table of your database and impact the performance of RunMyJobs. Redwood recommends scheduling the System_ArchiveEvents Process Definition once per day. Consider keeping one month of events (maximum 10,000 events or three months, depending on frequency).

Note: If you have a large number of events, the System_ArchiveEvents Process Definition can potentially fail. If this happens, use the parameters to archive very old events first and progressively archive the rest until you are happy with the result. Submit the process with a regular schedule; ideally using the desired age of events.

Operator Messages

Operator Messages can accumulate over time, especially if they are heavily used. For example, an Operator Message is generated automatically whenever a Process fails. Having too many Operator Messages can slow down your system. To avoid this, Redwood recommends scheduling System_RemoveOperatorMessages to run every day. You can use this Process Definition to remove Operator Messages by age or date.

The first Parameter is Automatically reply to messages? If this is set to No, Operator Messages that are waiting for replies are not deleted, and can accumulate over time. To see how many unreplied-to Operator Messages are present, navigate to Monitoring > Operator Messages and choose All Operator Messages Awaiting a Reply from the dropdown list at the top. If there are too many, set Automatically reply to messages? to Yes when you submit System_RemoveOperatorMessages. The Process will try to reply to any Operator Messages that (a) require a reply, and (b) have a previous reply that matches one if the options in its reply list.

Note: If you set Age or Date to Age, but you do not specify values for Age or Age Units, the process will use Age = 3 months.

Best Practice: Operator Messages

Keep 1-3 months of Operator Messages and schedule the process to run daily.

Audit Records

Audit records accumulate over time and can slow down the system. Consequently, Redwood recommends scheduling System_ArchiveAuditObjects to run on a daily basis. This Process Definition will export audit data in XML format and then delete it. You can also run System_ExportAuditObjects if you just want to view the audit records in XML format.