Tools → Load Job Details Viewer
About the Load Job Details Viewer
The Load Job Details Viewer is a tool available to schema managers to review the status and history of a load job. By default, the Load Job Details Viewer shows the schemas, objects, and details of a load job. In addition, it lists the history of the related load jobs.
Load Job Details Viewer access rights
A Super User or a user that belongs to a group with the SuperRole or Schema Manager role can access the Load Job Details Viewer to view the details of load jobs related to schemas that the user owns or has access rights to. When the Cluster Management Console (CMC) admin turns the Enable Super User Mode option on, the Super User and users with the SuperRole can access the Load Job Details Viewer of all load jobs regardless of the access rights to the related schemas.
To access the Load Job Details Viewer, do on of the following:
- In the navigation bar, select Schema, select the Load Jobs tab, and then select a load job.
- In the navigation bar, select Schema, and then on the Schemas tab, select the status or time of the latest or current load job.
- In the navigation bar, select Schema, and then on the Schemas tab, select a schema. On the Schema Designer, select the status or time of the latest or current load job.
Enhancements introduced in the Load Job Details Viewer
- Shows single-schema and multi-schema jobs.
- Shows and differentiates between scheduled and manual schema jobs.
- Shows the total rows per object.
- Shows the tool used to invoke the job.
- A manual load job is one that users invoke either using the application UI (via the Schema Designer) or an API endpoint.
- A scheduled load job is one that the Scheduler runs depending on load plans with one or more physical schemas.
Anatomy
The Load Job Details Viewer consists of the following:
- Page header
- Load job history
- Load job details
Page header
The page header shows the following:
- Breadcrumb navigation
- The schema or load plan name
- The last refresh time of the load jobs and details
Load job history
This part shows the history of load jobs related to the job that you select on the Load Jobs list.
- If you select a load job of a scheduled load plan with multiple schemas, this list shows all the load jobs of this load plan, that is, the runs of this scheduled load plan.
- If you select a load job that you or another user manually invoked for a specific physical schema (via the application UI or APIs) or a load job of a scheduled load plan with a single schema, the list shows
- All manual load jobs of this physical schema, including those that other users invoked, whether via the application UI or APIs
- Load jobs of all load plans with this single schema
The load job history list shows the following details for each load job:
- Status (icon): You can filter the job list by the job status.
- Job Starting Time: The job start time. By default, the list is sorted in descending order according to the job start time.
- Duration: The time elapsed during the load job. You can sort the list according to the load job duration.
Load job details
This part shows the details of the selected load job, including the physical schemas and objects. By default, this part shows the details of the load job you selected on the Load Jobs list. However, you can select another job to show its details.
This part shows also the start time of the selected load job along with its status and type: manual or scheduled. When you hover over the job status, the elapsed time per phase appears. You can search for the objects and physical schemas in the selected load job.
This page shows the following details for each object in the load job.
| Column | Description |
|---|---|
| Schema | The schema name |
| Table | The object name |
| Extraction/Enrichment > Start | The start time of the object extraction or enrichment |
| Extraction/Enrichment > Duration | The elapsed time during of the object extraction or enrichment |
| Extraction/Enrichment > Extracted/Enriched Rows | The number of rows extracted or enriched for this object during this load job, including the rejected rows |
| Extraction/Enrichment > Rejected Rows | The number of rejected rows during the object extraction or enrichment |
| Load/Post-Load > Start | The start time of loading the object. All Load/Post-Load columns will show no data for non-performance-optimized objects. |
| Load/Post-Load > Duration | The elapsed time to complete the Load/Post-Load calculations for the respective object |
| Load/Post-Load > Loaded Rows | The number of rows loaded during the selected load job including those ● Loaded from the extracted/enriched rows ● With duplicates in the memory ● That failed to load during previous load jobs and were loaded during the selected load job |
| Total Rows | The total number of unique rows loaded into the Engine memory for the respective object after the selected load job, including rows loaded during previous load jobs and the selected load job. This number might be different from the current total number of rows loaded for the related object. For non-performance-optimized objects, the total rows are 0 as no rows from this object are loaded into the Engine memory. |
| Status | The load status per object |
By default, the schema/object list is sorted in ascending order by the table (object) name. You can use all columns to sort this list, except for the Schema and Load Type columns, which you can use, along with the Status column, to filter out the schemas and objects that appear on this list.