Help Center/ GaussDB/ Developer Guide(Distributed_8.x)/ System Catalogs and System Views/ System Views/ OLTP Table Compression/ GS_ADM_ILMRESULTS
Updated on 2024-06-03 GMT+08:00
View PDF
Share

GS_ADM_ILMRESULTS

GS_ADM_ILMRESULTS displays the execution details of an ADO job, including the task ID, job name, job status, and job time. By default, only the system administrator can access this system view. Common users can access the system view only after being authorized.

Table 1 GS_ADM_ILMRESULTS columns

Name

Type

Description

task_id

bigint

ID of an ADO task.

job_name

character varying(128)

ADO job name.

job_state

character varying(35)

ADO job status.

start_time

timestamp with time zone

Time when a job starts to be scheduled.

completion_time

timestamp with time zone

Completion time.

comments

character varying(4000)

If a job fails, the failure cause is recorded here.

statistics

clob

Statistics.

node_name

name

Name of a data source node.
Parent topic: OLTP Table Compression