GS_ILM_JOBDETAIL

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

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.