.png)
Viewing the status of purge or archive jobs [AX 2012]
Updated: October 26, 2011
Applies To: Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012
 Note |
|---|
| This is pre-release documentation of a preliminary nature and is subject to change at any time without notice. Microsoft cannot guarantee the accuracy of any information provided herein. |
This topic describes the options on the Status menu. They let you refresh the status of all currently running jobs, and provide details for all currently running and completed jobs. On the toolbar, click Status to open the Status workspace.
The following tables provide descriptions for the controls in the Status workspace.
Panes
| Pane | Description |
| Job status | Provides a list of all currently running, canceled, failed, or completed schedules. Each currently running or completed schedule is referred to as a job. This workspace uses the terms job and schedule interchangeably. Use the Show status details for previous option in the Administer > Framework options window to configure the number of jobs shown in this pane. |
| Status details | Provides status details of the selected job. |
| Trace | Lists the multiple steps and queries for the selected schedule, if there are any. |
Fields
Job status pane
| Field | Description | ||||
|---|---|---|---|---|---|
| Schedule name | The name of the schedule. | ||||
| Type | The type of the schedule. | ||||
| Last run time | The date and the time when this schedule was last run. | ||||
| Last run result | The result can be Pass, Fail, Running, or Canceled. The Data Management Framework and scheduler service log errors in their respective error log files. Use the following steps to restart a failed or canceled archive, revert, or restore archive schedule:
Use the following steps to revert a failed or canceled archive schedule:
| ||||
| Next schedule | The date and time for the next schedule for a recurring schedule. | ||||
| Description | The schedule description. By default, the Data Management Framework provides a brief description for the schedule, such as purge data for the selected Purge Object. The description does not provide any information about the rules in the Archive Object or Purge Object. You can modify the Data Management Framework configuration file to provide the rules and their values in the description. Use the following steps to modify the configuration file:
With the modified configuration file, when you create or update an archive or purge schedule, the schedule description includes all the rules and their values for the selected Purge Object or Archive Object. | ||||
| SSIS trace | This field is provides a hyperlink to view the Microsoft SQL Server Integration Services (SSIS) trace output for this schedule. The hyperlink is only available when you set the trace level to Verbose. Use the Framework options menu to set the SSIS trace level. |
Status details pane
| Field | Description |
|---|---|
| Type | The type of the schedule. |
| Status | The status can be Pass, Fail, Running, or Canceled. You must run a failed, or canceled, job again. Determine the effect of the status on any currently running or future schedules. |
| Start time | The start time of the schedule. |
| End time | The end time of the schedule. |
| Created datetime | The date and time when the schedule was created. |
Trace pane
All schedules contain the following fields. The archive and restore archive schedules do not provide Start time and End time fields, but provide the Duration field instead.
| Field | Description |
|---|---|
| Start time | The start time of the subtask. This field is available for all schedules except for the ledger periods, archive, and restore schedules. |
| End time | The end time of the schedule. This field is available for all schedules except for the ledger periods, archive, and restore schedules. |
| Status | The completion status for all schedules is either Pass or Fail. The archive and purge schedules also show the status as Running when a schedule is active. For a failed schedule, check to see which subtask has failed before you run the schedule again. Determine the effect of the failed schedule or running the schedule again on any other schedules. |
Trace pane for analysis snapshot schedules for production and archive databases
| Field | Description |
|---|---|
| Subtasks | A subtask is a step in a task, such as Index analysis snapshot or Table analysis snapshot. The Trace pane lists all subtasks for a given schedule, where applicable. |
Trace pane for master data synchronization schedules
| Field | Description |
|---|---|
| Table name | The table name in the Purge Object. |
| Rows inserted | The number of rows inserted into this master table, from the production database to the archive database. |
| Rows updated | The number of rows updated in this master table, from the production database to the archive database. |
Trace pane for metadata synchronization schedules
| Field | Description |
|---|---|
| Subtasks | The name of the subtask that the metadata synchronization schedule performs. Each subtask corresponds to a database object, such as a function, index, primary key, stored procedure, table, or view. |
| Production DB count | The number of objects found in the production database. |
| Archive DB count | The number of database objects copied to the archive database. The values of Production db count and Archive db count must match for Table, Index, and Primary key subtasks. In case of a mismatch in these counts, the metadata synchronization schedule fails. |
Trace pane for system health check schedules
| Field | Description |
|---|---|
| Period | The period is a four-digit calendar year based on ledger periods. |
| Measure | A description of the measure. |
Trace pane for purge schedules
| Field | Description |
|---|---|
| Table name | The name of the table in the Purge Object. |
| Records recycled | The total number of records recycled from this table by the purge schedule. |
| Records inserted into the purge table | The total number of records inserted into the purge table. The purge table contains all records that are recycled from the production database, until you remove them from the purge table. This value is the same as the number of records recycled. |
Trace pane for archive schedules
| Field | Description |
|---|---|
| Table name | The name of the table in the Archive Object or Related Archive Object. |
| Records inserted into the temporary tables | The total number of records inserted into the temporary table that was used as the source for this archival activity. |
| Records inserted into the archive database | The total number of records inserted into the tables in the archive database from the corresponding tables in the production database. This number must match the number of records in the source database. |
| Records offlined | The total number of records archived, or in other words, the total number of records that were copied from the production database to the archive database, and then deleted from the production database. |
| Summation count | The total number of adjustment records inserted into the production database. You may have to make adjusting entries to balance the affected accounts. |
| Duration | The time required to complete this archival step. Various stages of the data archival process run at different times for each table in an Archive Object. As a result, the data grid provides a duration instead of a start time and an end time. |
| Status | The status of the subtask, such as Pass or Fail. |
Trace pane for restore archive schedules
| Field | Description |
|---|---|
| Table name | The name of the table in the Archive Object or Related Archive Object that is being restored. |
| Archive date | The archive date and time. |
| Records qualified for restoration | The total number of records that were selected based on the company and period you selected for a calendar year. |
| Records restored | The total number of records restored from the archival database to the production database for this table. |
| Summation count | The total number of adjustment records deleted from the production database. |
| Records deleted from archive database | The total number of records deleted from the archive database for this table. |
| Duration | The time required to complete this archival step. Various stages of data archival process run at different times for each table in an Archive Object. As a result, the data grid provides a duration instead of a start time and an end time. |
| Status | The status of the subtask, such as Pass or Fail. |
