Note
For OceanBase Database V4.3.5, this variable takes effect starting from V4.3.5 BP2.
Description
event_scheduler specifies whether to enable and run the event scheduler on the server.
Applicability
This variable applies only to the MySQL-compatible mode of OceanBase Database.
Privileges
Query variables
The
systenant and all user tenants can use theSHOW VARIABLESstatement or theSYS.TENANT_VIRTUAL_GLOBAL_VARIABLEview (Oracle-compatible mode) and theinformation_schema.GLOBAL_VARIABLESview (MySQL-compatible mode) to check the values of global system variables.Modify variables
The
systenant can directly modify the value of a global system variable.MySQL-compatible tenants need to have the
SUPERorALTER SYSTEMprivilege to modify the value of a global system variable.For OceanBase Database V4.x, Oracle-compatible tenants need to have the
ALTER SYSTEMprivilege to modify the value of a global system variable starting from V4.2.0.
Attributes
| Attribute | Description |
|---|---|
| Parameter type | Bool |
| Default value | OFF |
| Value range |
|
| Scope | GLOBAL |
| Modifiability | Yes |
Examples
Execute the following statement to enable the event scheduler:
obclient> SET GLOBAL event_scheduler=ON;