The RUN stored procedure immediately runs a job. It can run even broken jobs. next_date is recalculated when a job is run.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Syntax
DBMS_JOB.RUN (
job 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. |
| force | Specifies whether to forcibly run the job. If this parameter is set to TRUE, the job is run forcibly; otherwise, the job is run only when it is idle. |
Examples
CALL DBMS_JOB.RUN(10100);