Updated on 2024-04-29 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:

The concurrency refers to the number of concurrent SQL statements for a data connection.

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.

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.

  • 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.