Purpose
The oceanbase.DBA_OB_BALANCE_JOB_HISTORY view displays the history of all load balancing jobs executed in the current tenant.
Note
This view is introduced since OceanBase Database V4.2.0.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| JOB_ID | bigint(20) | NO | The ID of the load balancing job. |
| CREATE_TIME | timestamp(6) | NO | The time when the job was created. |
| MODIFY_TIME | timestamp(6) | NO | The end time of the job, which can be the time when the job was executed or canceled. |
| BALANCE_STRATEGY | varchar(64) | NO | The name of the load balancing strategy. Valid values:
|
| JOB_TYPE | varchar(64) | NO | The type of the job. Valid values:
|
| TARGET_UNIT_NUM | bigint(20) | NO | The target number of resource units for each zone. |
| TARGET_PRIMARY_ZONE_NUM | bigint(20) | NO | The target number of primary zones. |
| STATUS | varchar(64) | NO | The status of the job. Valid values:
|
| COMMENT | longtext | YES | The comment on the job. |