Apply table rotation

You can apply table rotation by specifying the time parameter (duration) of the process and the number of tables (totations) within.

Before you begin

Role required: admin

About this task

Note: Deployment of this plugin should be executed in partnership with a ServiceNow representative.

Procedure

  1. Navigate to System Definition > Table Rotations.
  2. Click New, or select the table rotation group to modify.
  3. Set the table rotation fields.
    Table 1. Table rotation group fields
    Field Description
    Name Enter the name of the table to which the action is to be applied.
    Duration Set the overall duration for the action.
    Initialized Sets table rotation as active (true) or inactive (false). [This must be checked (true) for the rotation or extension to be active.]
    Type Choose either Rotation or Extension.
    Rotations Sets the number of tables to be maintained through the duration.
    Clean base rotation Sets the date to clean (truncate) the base table.
  4. Click Submit or Update.
    Note: Deleting a rotation deletes the additional tables and all the data. Do not delete the rotation if the data is needed.

    When you define a new rotation, a schedule is created and new data is subsequently written to one of the tables in the rotation group. The group includes the original table plus a number of additional tables.

    New table rotation group