Thank you for your feedback.
Form temporarily unavailable. Please try again or contact to submit your comments.

Apply table rotation

Log in to subscribe to topics and get notified when content changes.

Apply table rotation

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

Before you begin

Role required: admin

About this task

Note: Deploy this plugin in partnership with a ServiceNow representative.


  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