Updated on 2024-06-03 GMT+08:00

GS_MY_ILMEVALUATIONDETAILS

GS_MY_ILMEVALUATIONDETAILS displays the evaluation details of an ADO task, including the task ID, policy information, object information, evaluation result, and ADO job name.

Table 1 GS_MY_ILMEVALUATIONDETAILS columns

Name

Type

Description

task_id

bigint

ID of an ADO task.

policy_name

character varying(128)

Name of an ADO policy, which is automatically generated. The name format is P + Policy ID.

object_owner

character varying(128)

Schema name of a data object.

object_name

character varying(128)

Data object name.

subobject_name

character varying(128)

Partition name of a data object.

object_type

character varying(18)

Data object type.

  • r: table
  • p: partition
  • s: level-2 partition

selected_for_execution

character varying(42)

Evaluation result:

  • SELECTED FOR EXECUTION: The evaluation is passed.
  • PRECONDITION NOT SATISFIED: The evaluation fails.
  • JOB ALREADY EXISTS: The task already exists.

job_name

character varying(128)

Name of the task that executes a specific ADO job. If the evaluation result is "passed", this parameter has a value.

comments

character varying(4000)

Reserved column.

node_name

name

Name of a data source node.