Purpose
You can use this statement to clear load balancing tasks that are not scheduled.
This statement can be executed only in the sys tenant.
Syntax
ALTER SYSTEM REMOVE BALANCE TASK opt_tenant_list opt_zone_list opt_balance_task_type;
opt_tenant_list
TENANT [=] tenant_name,tenant_name_list
opt_zone_list
ZONE [=] zone_name, zone_list
opt_balance_task_type
ALL
| MANUAL
| AUTO
Parameters
| Parameter | Description |
|---|---|
| opt_tenant_list | The list of tenants. If you do not specify this parameter, the tasks of all tenants are cleared. |
| opt_zone_list | Optional. The zone list. |
| opt_balance_task_type | The type of tasks to be cleared.
|
Examples
Clear all tasks that are not being scheduled for all tenants.
obclient> ALTER SYSTEM REMOVE BALANCE TASK;