Defining Archive Database Jobs

PASS databases can be archived using Schedule Job Agent.

Before you begin

Schedule Job Agent must be open.

Procedure

  1. Select a job from the grid.
    The scheduled job record settings are shown in the Job Schedule frame.
  2. Confirm the Agent Name PassScheduleAgent is defined for the job schedule.
    The selected agent determines the options that are available in the Job Type field.
  3. Click Job Data.
    The Job Data dialog box appears.
  4. Define the schedule type and date information:
    1. In the SchType field, click Live.
    2. In the Offset field, type 0.
      This forces the job to use today's date.
  5. In the Job Type field, select Archive Database. If no Job Types are available, confirm that an Agent Name has been selected in the Job Schedule frame of the Schedule Job Agent dialog box.
  6. Click New.
    The New Batch dialog box appears.
  7. Type a Batch name.
  8. Define the following:
    Batch name
    The name of the Archive Database batch.
    Number of days
    Number of days greater than which an archive should be created. Lowest number is 30.
    Archive DSN
    Database to be used as the archive database.
    Desired longest runtime in hours
    Limits the amount of archiving to be done in a single session.

    Tables are archived based on the processing power available for the action. For example, if 8 processors are available, 8 tables can be archived at the same time.

    If a table is currently being archived when the hour limit is reached, the table will finish being archived (unless strict runtime restriction is selected).

    Leave as 0 for no restriction. Note that this setting is not recommended until after an initial archive has occurred. Depending on the size of the database, this process can take days or weeks.

    strict runtime restriction
    Forces the system to finish immediately when the Desired longest runtime in hours is reached. The table currently being archived will be rolled back (unarchived).
    Date related tables to keep in source (comma-separated list)
    Tables that should be copied into the archive but also retained in the source database. For example, 
    Address,Clients,Alerts
    Tables are archived in the following order: core tables, log tables, date-related tables, booking-related tables, all other tables. All archive tasks are listed in the CDBlog.
  9. Click OK.
  10. Click OK.
    The Job Data dialog box closes.
  11. Click Save.
  12. Click Close.