1. On-premises 6.0
  2. Guides
  3. Concepts
  4. Tools
    1. Alert Editor
    2. Alias Sync Tool
    3. Analyzer
    4. Apache Parquet Merge Tool
    5. Avro Extractor Tool
    6. Business Schema Designer
    7. Business Schema Manager
    8. Cluster Management Console
    9. CMC Logs Manager
    10. CMC Monitoring
    11. CMC Patch Manager
    12. CMC Scheduler
    13. CMC Tenant Manager
    14. Command Line Interface
    15. Content Manager
    16. Dashboard Filters Manager
    17. Dashboard Manager
    18. Data Agent
    19. Data APIs for External Notebooks
    20. Data Lineage Viewer
    21. Data Manager
    22. Formula Builder
    23. Inspector Tool
    24. Join Editor
    25. Load Job Details Viewer
    26. Model Update Viewer
    27. Notebook Editor
    28. Profile Manager
    29. Public API
    30. Query Plan Viewer
    31. Scheduler
    32. Schema Designer
    33. Schema Diagram Viewer
    34. Schema Manager
      1. Schemas
      2. Load Jobs
      3. Session Variables
      4. Global Variables
    35. Schema Wizard
    36. Security Manager
    37. Table Editor
    38. Tenant Management Tool
    39. Upload Service Command Line Interface (CLI)
    40. Versioning Migration Tool
  5. References
  6. Integrations
  7. Data applications
  8. Releases

Tools → Schema Manager → Load Jobs

About the Load Jobs list view

The Load Jobs tab is available on the Schema Manager starting the 6.0 release. The Load Jobs tab helps schema managers to monitor, search, view, and manage load jobs of schemas and load plans, whether running or recent load jobs. It also allows them to spot issues with these load jobs.

Note

The multi-schema load plans feature is a preview feature as of the 6.0 release.

The Load Jobs tab displays only one record per schema or load plan. It lists load jobs, whether manually started for a specific physical schema or automatically started via scheduled load plans with one or more physical schemas.

Load Jobs access rights

A Super User or a user that belongs to a group with the SuperRole or Schema Manager role can access the Load Jobs tab. However, the load jobs that a user can view on this page may vary depending on the access rights each user has on the different physical schemas. For details, see List view.

To access the Load Jobs tab, in the navigation bar, select Schema, and then select the Load Jobs tab.

Load Jobs anatomy

The Load Job page consists of the following:

  • Search bar
  • List view

The Search bar shows

  • A search text box to find schemas or load plans on this page
  • The number of items in the result list
  • The synchronization time of recent jobs and their statuses, whether this synchronization is automatic (when you access the page) or manual (when you select to refresh the list)
  • Refresh (circular arrow icon): Refreshes and synchronizes the recent jobs and their statuses

List view

The list view displays only one record per schema or load plan that has a current or previous load job. To view the load job details and history, select the related record. When searching the load jobs by schema or load plan name, the list view shows the results for the given search term. The list view shows 50 load jobs at a time. For lists with more than 50 jobs, the view contains page controls to navigate forward or backward as well as to the first page or to the last page of jobs.

Note

When you delete a physical schema, it won't appear on this list even if it had load jobs.

Load jobs to display on this page may vary depending on your access rights on the different physical schemas.

  • You can view the load jobs of all physical schemas that you own or have access rights to, whether View, Share, or Edit.
  • You can view the load jobs of load plans that include at least one of the physical schemas that you own or have access rights to, whether View, Share, or Edit.
Note

When the Cluster Management Console (CMC) admin turns the Enable Super User Mode option on, the Super User and users with the SuperRole can view and manage all load jobs regardless of the access rights.

The following table shows the details that appear per load job.

ColumnDescription
StartedThe job start time.
StatusThe status of the load job. You can filter the job list by status. When you hover over the job status, the elapsed time per phase appears.
Load PlanThe name of the load plan if the job is executed based on a scheduled plan. If the load job is manually executed, it will be empty.
SchemasThe schemas in the load job, whether a single schema or multiple schemas. You can expand to display the related schema list.
DurationThe duration of finished load jobs or the elapsed time of running load jobs.
EndedThe job end time. For running and in-queue load jobs, it will be empty.
Executed ByThe name of the person who initiated the job. It is empty for scheduled jobs.
ActionsYou can stop a running load job if you own or have Edit access rights to all schemas in the job.
Note

In the case of a single-schema load plan, the schema name appears instead of the load plan name. As a result, only one record will appear for all the single-schema load plans related to the same schema. In addition, when you select one of the related load jobs, the load jobs of all these load plans will appear on the Load Job Details Viewer page.

What can you do by using this tab?

Search, filter, and sync the load job list

  • To search for a load job by the schema or load plan name, in the search box, enter the name or part of it.
    • The search bar shows the number of jobs that match the search term.
    • To reset the list, select the remove (x) icon in the search box.
  • To filter the job list by status, select the filter (funnel) icon in the Status column header, select the statuses you want to filter, and then select OK.
    • The search bar shows the number of jobs that match the selected statuses.
    • To remove the filter, select the filter (funnel) icon in the Status column header, select Reset, and then select OK.
  • To synchronize the load jobs and their statuses, select the refresh (circular arrow icon) icon in the search bar.

Sort the load job list

By default, the list is sorted in descending order according to the start time. You can use the following columns to sort the load job list in an ascending or descending order:

  • Started
  • Load Plan
  • Duration
  • Ended
  • Executed By

To sort the job list using a different column:

  1. Select the header of one of the sortable columns to sort the list in ascending order by this column.
  2. Select the same header again to sort the list in descending order by this column.

View the job details

  • To view the details of a load job, select its record. The Load Job Details Viewer page opens showing the details of the selected job and the related job history.

Stop a running load job

You can stop a single schema load job if you own or have Edit access rights to this physical schema. You can also stop a load plan load job only if you own or have Edit access rights to all physical schemas in this plan.

  1. To stop a running load job, in the respective record, select Stop.
  2. In the warning message, select Stop.