The WHAT stored procedure changes the functionality of an existing job.
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. |
Usage notes
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);'