Run scheduled job to back up staging table
You can take a backup of the data on the staging table at periodic intervals.
Before you begin
Role required: admin
About this task
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.
Note: Import tasks that are in a Canceled or Closed state aren’t backed up.
Procedure
Navigate to All > System Definition > Scheduled Jobs.
Find the Scheduled Staging Data Backup Job scheduled job.
Note: The job is inactive by default. Select the Active check box to run the scheduled job at the scheduled time.
Select Execute Now.
To configure the backup period, specify a number in the Value field for the
sn_acct_lc.BackupDayssystem property. For example, if the Value field is set to 2, data that is more than two days old is included in the backup.
Result
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.
Parent Topic:Configure the account onboarding playbook