Maintenance Job Status

The maintenance job synchronizes configuration data between ADP Workforce Manager and Data Hub. When the job finishes, it has a status of Success or Failure. This status displays in the Portal, showing when the job ran successfully and when it had errors.

From the Maintenance Job Status page, view the name and status of maintenance jobs run within the past seven days, and the date and time they were last updated.

The maintenance job runs nightly. Your Data Hub administrator may also run the maintenance job on an as needed basis. These on-demand jobs are in addition to the regular nightly schedule.

Note: Maintenance jobs are not started from the Portal. See your administrator for more details.

The maintenance job runs nightly and synchronizes information between ADP Workforce Manager and Data Hub and between BigQuery and Data Hub. The information includes new and changed configurations needed in Data Hub so that you can configure pipeline setting values and mappings. Then, when a paycode is mapped, it is delivered to BiqQuery's data structure which uses the mapping information.

BigQuery needs to know about any new or changed mappings. For example, if new paycodes are added to ADP Workforce Manager, the nightly maintenance job processes the new paycodes and deliver them to BigQuery. After the configuration maintenance job runs successfully, map the paycodes, then run the wrapper/pipelines associated with the paycodes.

When you do not see expected configurations, including new paycodes from ADP Workforce Manager, review the recent maintenance jobs. A current Failed status indicates potential problems that may need your attention, including a paycode not delivered to Data Hub or a mapped paycode not loaded into BigQuery.

To subscribe to maintenance job alerts, see Alert Subscriptions.

The following maintenance jobs are available:

  • WFD Sync. These jobs extract ADP Workforce Manager mapping configuration details and deliver them to Data Hub.
    • WFD Sync: Paycode. Extracts paycodes that need to be mapped.
    • WFD Sync: Custom Driver. Extracts the custom drivers that need to be mapped.
    • WFD Sync: Location Type. Extracts business structure location types that need to be mapped.
  • BigQuery Sync. These jobs deliver configuration details from Data Hub to Google Cloud BigQuery.
    • BigQuery Sync: Paycode. Delivers paycode mapping changes.
    • BigQuery Sync: Custom Driver. Delivers custom driver mapping changes.
    • BigQuery Sync: Pipeline Settings. Delivers pipeline settings changes.

Go to the Setup > Maintenance Job Status page. Details about maintenance jobs run on the tenant in the last seven days display in the following columns:

  • Name. The name of the maintenance job type.
  • Status. Either Success or Failure. If a job fails, you may need to run a pipeline again or map a paycode.
  • Updated On. The date and time the job completed.

The top of the page displays the names of any failed jobs and the reason they failed.