Name
DROP_JOB
Synopsis
This procedure drops a job when it is no longer needed.
Parameter name |
Datatype |
Description |
job_name |
VARCHAR2 |
Name of the job to be dropped. You can also specify a series of jobs separated by commas (e.g., “JOB1,JOB2”, etc.). |
Alternatively, you may specify the name of a job class. If a job class is specified, then all the jobs under the job class are dropped. | ||
Note that you cannot drop a job class by specifying it here. You have to use DROP_JOB_CLASS procedure . | ||
force |
BOOLEAN |
If the job is currently running, then it can’t be dropped. Setting this parameter to TRUE makes the procedure attempt to stop the job first before dropping it. The default is FALSE, which results in an error when DROP_JOB is issued. |
Get Oracle PL/SQL for DBAs now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.