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

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.