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

GS_ADM_ILMEVALUATIONDETAILS

GS_ADM_ILMEVALUATIONDETAILS displays the evaluation details of an ADO task, including the task ID, policy information, object information, evaluation result, and ADO job name. By default, only the system administrator can access the system view.

Table 1 GS_ADM_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)

Name of the schema where the data object is located.

object_name

character varying(128)

Data object name.

subobject_name

character varying(128)

Data object partition name or level-2 partition name.

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.