Run an archive, purge, and restore job manually

You can manually run the archive and purge jobs on the MES database to archive and/or purge the data and run the restore jobs on the non-production database. You can manually select one of the APR jobs currently defined in the MES database for execution. When you select a job, all configuration information for that specific job is shown. You can review and modify the specifications for the job before executing it.

If you run an archive job or an archive purge job, the following is created on the DB Maintenance Service (at the configured root path):

• A directory is created with the job name, if it doesn't exists already

• Under the job directory, a time-stamped Zip file is created that contains a CSV file for each archived table. The Zip file also contains a manifest file. A log file with the same name is created alongside the Zip file.

If you run a purge job or a restore job, the following is created on the DB Maintenance Service (at the configured root path):

• A directory is created with the job name, if it doesn't already exist

• Under the job directory, a time-stamped log file is created

  Note: If you run a restore job, the following warning is shown: Restoring to an operational production database is not supported. Executing this type of restore will likely cause performance issues and possible transaction failures. Do you wish to proceed?.

Run an APR job manually

1. Select the job.

2. Do one of the following:

   • Right-click the job and on the context menu click Run.

   • On the ribbon, go to the Current View tab and click Run.

   The execution status of the job is changed to running until the job is complete or aborted.

You cannot execute an already running job.