System Activity Purge

Job type: JavaClosed A widely used object-oriented programming language that is designed for use in the distributed environment of the internet. It is the most popular programming language for Android smartphone applications

Batch job name: System Activity Purge

Archive: None

For more information on this job, see the Job Details in the Administration ConsoleClosed An operations web console that allows batch jobs to be scheduled, run manually and monitored. The console also provides for viewing and modification of business and user applicable system configuration.: In the console, navigate to System Maintenance > Jobs. In the Job List, click the name of job to open its Job Details screen.

This job is responsible for the purge of CMPClosed Converged Monetisation Platform. The MDS Global product that supports customer care and billing for digital service providers. system activity data, for example, records generated by the batch job framework, records of AgentViewClosed The graphical user interface of the CMP that is typically used by Customer Service Agents to access CMP customer and billing data. In versions prior to CMP 8.0, this was called the CMP GUI. activity, records of provisioningClosed In telecommunications, the setup of equipment, wiring and transmission to deliver services to a customer. activity and records of probeClosed In the Administration Console architecture, a mechanism which allows for the execution of predefined queries and for the comparison of the results of those queries against pre-configured targets. Probes can be reviewed and managed via the Admin Console. and alert history. This job purges system activity records from:

  • The Activity table, which holds records that are accumulated into the Activity Summary record and used by the CMP batch framework to generate job execution estimates. The job deletes records where ENDDATETIME <= the calculated purge date.

  • The NetworkRequestLog table, where AUDITTIMESTAMP <= the calculated purge date AND the status of the associated event is Resolved, along with their associated child record in s:

    • The NetworkRequestLogHistory table.

    • NetworkActivityLog table, where child records have:

      • Activity Type of 1

      • ActivityReference=Action Item Number of the NetworkRequestLog record.

  • The AuditHeader table where EVENTTIME <= the calculated purge date, along with the associated child records in the AuditDetail table.

  • The ProbeHistory table, where the probe and alert records are deleted as defined in the Months to Retain field.

  • Spring Batch framework records:

    • Records in the Batch_Job_Execution table where LAST_UPDATED_DATETIME <= the calculated purge date are deleted along with their associated child records in the following tables:

      • Batch_Job_Instance

      • Batch_Job_Execution_Context

      • Batch_Job_Execution_Params

      • Batch_Step_Execution

      • Batch_Step_Execution_Context

Each invocation of the job produces a summary audit of system activity data removed.

Selection criteria

The job accepts a single parameter - Months to Retain. This represents the number of months worth of data to retain. The job subtracts this parameter from the current date to calculate a purge date. Only system activity data dated on or before the calculated purge date is purged. Any system activity data prior to the retention period will be permanently removed.

A value of zero (0) is not allowed as a parameter.

Tables Impacted:

Running the purge job

In the Administration Console, you can create a schedule for the purge job or run it as needed.

To run a job:

  1. Navigate to Daily Operations > Jobs.
  2. In the Job List, select the checkbox for the job that you want run.
  3. Click Run Now.