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

GS_MY_ILMRESULTS

GS_MY_ILMRESULTS displays the execution details of an ADO job, including the task ID, job name, job status, and job time.

Table 1 GS_MY_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.