The WHAT stored procedure changes the functionality of an existing job.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Syntax
DBMS_JOB.WHAT (
job IN BINARY_INTEGER,
what IN VARCHAR2);
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. |
| what | The PL stored procedure to run. |
Considerations
Before a job is submitted, it cannot be handled by the job queue in the background.
Sample valid values of the
whatparameter (assuming that the stored procedure already exists):'myplproc(''12-FEB-21'', next_date, broken);''dbms_job.remove(job);'