The ZONE stored procedure modifies the association between a job and a zone.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Syntax
DBMS_JOB.ZONE (
job IN BINARY_INTEGER,
zone IN BINARY_INTEGER,
force IN BOOLEAN DEFAULT FALSE);
Parameters
| Parameter | Description |
|---|---|
| job | The unique ID of the job to be modified. You can query this ID from the JOB column of the USER_JOBS or DBA_JOBS view. |
| zone | The zone where the job runs, which can be specified when you submit the job. |
| force | If you set this parameter to TRUE, a validity check is performed for the specified zone. Otherwise, validity check is not performed for the zone. |
Considerations
The zone where the job runs, which can be specified when you submit the job.
