Overview
The oceanbase.DBA_OB_TTL_TASKS view displays the execution status of TTL tasks for the current tenant in SQL mode.
Columns
field |
Type |
Is NULL |
Description |
|---|---|---|---|
| TABLE_NAME | varchar(256) | NO | Table name |
| TABLE_ID | bigint(20) | NO | Table ID |
| TASK_ID | bigint(20) | NO | The ID of the current batch task. |
| START_TIME | timestamp(6) | NO | Task Start Time |
| MODIFIED_TIME | timestamp(6) | NO | Row Update Time |
| TRIGGER_TYPE | varchar(8) | NO | Task trigger type:
|
| STATUS | varchar(10) | NO | Task status:
|
| RET_CODE | varchar(512) | NO | Error code returned at the end of the task |
| TASK_TYPE | varchar(10) | NO | TTL task type:
|
References
View the execution history of all user tenant TTL tasks: CDB_OB_TTL_TASK_HISTORY