Help Center/ GaussDB/ Developer Guide(Distributed_V2.0-8.x)/ System Catalogs and System Views/ System Catalogs/ OLTP Table Compression/ GS_ILM_JOBDETAIL
Updated on 2025-08-19 GMT+08:00
View PDF

GS_ILM_JOBDETAIL

The GS_ILM_JOBDETAIL system catalog records policy action types and judgment conditions.

Table 1 GS_ILM_JOBDETAIL columns

Name

Type

Description

taskoid

bigint

OID of an ADO task.

jobtype

"char"

Current job type: compression ('c').

jobstatus

smallint

Current job status:

  • 1: JOB CREATED
  • 2: COMPLETED SUCCESSFULLY
  • 3: FAILED
  • 4: STOPPED
  • 5: JOB CREATION FAILED

jobname

text

The ADO job name is unique in the table and is joined with job_name in the PG_JOB system catalog.

starttime

timestamp with time zone

Start time.

completetime

timestamp with time zone

Completion time.

payload

text

PL/SQL code of the current job.

statistics

text

Statistics of the current job.

comments

text

Description of the current job execution, such as the failure cause.
Parent topic: OLTP Table Compression