Run scheduled job to back up staging table

  • Freigeben Version: Australia
  • Aktualisiert 12. März 2026
  • 1 Minute Lesedauer

    • You can take a backup of the data on the staging table at periodic intervals.

    Vorbereitungen

    Role required: admin

    Warum und wann dieser Vorgang ausgeführt wird

    Data present in the staging table backed up if:
    • Import tasks are in an Active state.
    • The data creation date is earlier than the current date.
    Hinweis:
    Import tasks that are in a Canceled or Closed state aren’t backed up.

    Prozedur

    1. Navigate to All > System Definition > Scheduled Jobs.
    2. Find the Scheduled Staging Data Backup Job scheduled job.
      Hinweis:
      The job is inactive by default. Select the Active check box to run the scheduled job at the scheduled time.
    3. Select Execute Now.
      To configure the backup period, specify a number in the Value field for the sn_acct_lc.BackupDays system property. For example, if the Value field is set to 2, data that is more than two days old is included in the backup.

    Ergebnisse

    A CSV file is created and attached to the import task. The file name includes the name of the staging file and the creation date in the format stagingTable-dateCreated.csv.