Updated on 2024-10-23 GMT+08:00

Viewing Job Instances

GUI Description

The following figure shows the areas and buttons on the O&M page.

Figure 1 O&M page

Table 1 O&M page

No.

Area

Description

1

Navigation bar

Contains the storage directory of data quality rules.

You can store rules in different directories tailored to service requirements. The number next to each directory indicates the number of rule instances stored in the directory.

2

List of rule instances

Displays the instance name, type, running status, and running result.

3

Management area

Provides buttons for exporting, deleting, and stopping selected instances.

4

Search area

  • Displays rule instances based on specified conditions. For example, you can display rule instances for a specified time range.
  • Displays a list of instances according to the handler or instance name. Fuzzy search is supported.

5

Concurrent SQL statements

Click SQL. In the displayed Configure Concurrent SQL Statements for a Connection dialog box, set the number of concurrent SQL statements. Enter a value from 10 to 1,000. Click OK.

NOTE:

If the maximum number of SQL statements that can be executed for a data connection has been reached, the excess SQL statements will be queued.

Table 2 List of rule instances

Parameter

Description

Instance Name

Consists of a rule name and a number. The larger the number is, the later the instance is created.

Type

Displays the job type. The value can be Quality Job or Comparison Job.

Running Status

Displays the running status of an instance, such as Successfully, Failed, Running, and Alarming. In the right pane, you can view the detailed run logs of the rule instances.

  • Successfully: The instance stops normally and the running result meets the expectation.
  • Failed: The instance stops unexpectedly.
  • Alarming: The instance stops normally, but the running result does not meet the expectation.
  • Running: The instance is running, but no running result is displayed.
  • Timeout: The instance has timed out and is in Failed state.

Notification

Displays the notification status of an instance, such as Successfully, Failed, and Not triggered.

Operator

Displays the operator of the instance.

Created

Displays the time when the instance was created.

Start Time

Displays the time when the instance starts to run. The start time can be sorted in ascending or descending order.

Running Duration

Displays the running duration of the instance.

End Time

Displays the time when the instance execution is complete. The end time can be sorted in ascending or descending order.

Handled By

Displays the handler of the instance.

Rerun

Allows you to run a rule instance again.

Details

Displays the running results and logs of job instances.

  • Quality Job Result

    In the running result of a quality job, you can query the running status (normal or alarming) of each rule. If the quality job status is alarming, you can view the rule that triggers the alarm.

    The quality job running result can contain statuses of subjobs, which can be filtered by name or status.

  • Comparison Job Result

    In the running result, the left pane displays the execution result of the rule for source table rows, and the right pane displays the execution result of the rule for destination table rows. The error rate indicates the difference between the number of rows of the source and destination tables. If the error rate is 0, the source and destination tables have the same number of rows.

More > Rectify

Allows you to perform further processing on a rule instance. For example, you can Provide defects directly, Close defects, or Specify a user to rectify fault.

The above operations can be performed only when you are the handler of the instance.

More > Refresh Job Status

Refresh the job status.

More Operations

  • Exporting job instances

    Select job instances and click Export. In the displayed Export Instance Running Results dialog box, click Export. On the Export Records tab page, you can check whether the selected instances are successfully exported. You can also download the job instances that have been exported.

  • Deleting job instances

    Select job instances and click Delete.

  • Stopping job instances

    Select job instances and click Stop.

  • Rerunning a job instance

    Locate a job instance and click Rerun in the Operation column.