Scheduling archiving jobs

Once you have defined an archive policy, you need to schedule an archive task in the Job Scheduler.

  1. Select Maintenance > System Administration > Job Scheduler.
    The Task Schedules page is displayed.
  2. Click Add Schedule.
    The Task page is displayed.
  3. Specify the following:
    Task Description
    Name of the task.
    Task Type
    Type of the task. Select Archive Policy Runner.
    Task Affinity

    Specify the task to a specific scheduler to be run. By assigning tasks to various schedulers, the system can distribute the running of tasks across different schedulers, which may be running on different machines.

    Run at
    Time when this task is run.
  4. Select a scheduling option from the Scheduling Time section.

    The Archive Policy Runner Task should be set to run frequently during the day. The following two selections are typically used:

    Once
    To schedule only one run on this task.
    Daily
    To schedule runs by intervals of days and minutes:
    • Every Day(s): Specify the number of days between runs.
    • Interval Second(s): Specify the number of seconds between runs. The system allows for a minimum of 5 seconds between runs (-1 indicates that the field is not used).
  5. Specify this information:
    Start On
    Day on which the runs for the task begin. Required field.
    End By
    Day on which the runs for the task end. Optional field.
  6. Click Submit.
  7. Click OK.
    The Job Scheduler page is displayed. The Archive Policy Runner task that you have added is displayed in the Job Scheduler.
  8. Click Parameters next to the Archive Policy Runner Task.
  9. Specify the policies to run in the Archive Policies field. If policies are not specified, then all the policies are run.
    By default, the Archive Policies value is set to ALL. We recommend that the Archive Policies value remain set to ALL. This setting makes the registry value for archive boundary date (ARCHIVE_BOUNDARY_DATE) an accurate representation of the data state.
  10. In the Archive up to field, select the checkbox for:
    • how many days ago
    • exact end date
  11. Click Submit.
The following is a sample Oracle Archive Schema datasource definition:
archiveInstance=jdbc:oracle:oci8:@ROWB1DEVLDV
archiveDriver=oracle.jdbc.driver.OracleDriver
archiveUsername=archive
archivePassword=workbrain