Create an archive job

You can create a new archive job to execute a defined archive operation. This job will retrieve selected records from the MES database and record them in an archive file. You can also configure the archive jobs to execute a purge operation on the archived records following the successful completion of the archive operation.

Create an archive job

1. Do one of the following:

   • Press the Ctrl+N keys.

   • Right-click in the tab and on the context menu click New.

   • On the ribbon, go to the Home tab and click New.

   A new database job record is added.

2. In the new job's Properties window, complete the following settings:

   Name

   The unique name for the job.

   Description

   A description for the job.

   Type

   Select Archive.

   Details icon

   Click the Details icon to view and select the tables to archive from an available list.

   The tables in the Details list are the top-level tables in the MES database and so they are independent of each other. Selecting any of these tables will not include any of the others listed here. Therefore, make sure that you select each independent table that you want to include in the archive operation. To see which dependent and related tables are included in the archive with each of these independent tables, see Historical database tables.

   You can select the Work Order State Filter status from the available options, such as Released, Started, Completed, and Closed. In case of the Sample table, you can only archive samples that have their status set to Missed, Complete, Complete Late, or Canceled or samples that have the final flag set to True.

   Purge

   Specifies whether to purge the archived data.

   Date Filter

   Do any one of the following:

   • Click Relative and specify the number of days to select the data for archiving the records. If the number of days defined is 30, it will archive the data older than 30 days from the current date.

   • Click Absolute and then specify the From and To date to select the data for archiving the records.

3. Save the changes.

You can modify the properties of an existing archive job in the Properties window.