Purpose
This statement is used to clear load balancing tasks that are not scheduled.
This statement can only be executed 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, ...]
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 this parameter is not specified, all tasks of all tenants are cleared. |
| opt_zone_list | The list of zones. This parameter is optional. |
| opt_balance_task_type | The type of task to be cleared:
|
Examples
Clear all load balancing tasks that are not scheduled for all tenants.
obclient> ALTER SYSTEM REMOVE BALANCE TASK;