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

GS_MY_ILMTASKS

GS_MY_ILMTASKS displays the brief information about an ADO task, including the task ID, task owner, status, and time.

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