Create a purge job

You can create a purge job to execute a purge operation. This job will remove records from an active, production MES database to free-up resources on the database server. The purge operation can be done independently or as a follow-up to an archive job.

Create a purge 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 Purge.

   Select the categories of data to purge from a predefined list.

   Details icon

   Click the Details icon to view and select the tables to purge 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 purge operation. To see which dependent and related tables are included in the purge with each of these independent tables, see Historical database tables.

   In case of the Sample table, you can only purge samples that have their status set to Missed, Complete, Complete Late, or Canceled or samples that have the final flag set to True.

   Date Filter

   Do any one of the following:

   • Click Relative and then specify the number of days to select the data for purging the records. If the number of days defined is 30, it will purge 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 purging the records.

3. Save the changes.

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