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

GS_ADM_ILMTASKS

GS_ADM_ILMTASKS displays the brief information about an ADO task, including the task ID, task owner, status, and 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_ILMTASKS columns

Name

Type

Description

task_id

bigint

ID of an ADO task.

task_owner

character varying(128)

User who initiates an ADO task. This column exists only in the ADM view.

state

character varying(9)

Status.

  • INACTIVE
  • ACTIVE
  • COMPLETED
  • UNKNOWN: being evaluated

creation_time

timestamp with time zone

Creation time.

start_time

timestamp with time zone

Time when the status changes to active.

completion_time

timestamp with time zone

Completion time.

node_name

name

Name of a data source node.