Name
STOP_JOB
Synopsis
This procedure stops a running job.
|
Parameter name |
Datatype |
Description |
|
job_name |
VARCHAR2 |
Name of the job to be stopped. You can also specify a series of jobs separated by commas (e.g., “JOB1,JOB2”, etc.). |
|
Alternately, you may specify the name of a job class. If a job class is specified, then all the jobs under the job class are stopped. | ||
|
force |
BOOLEAN |
If the job is currently running, this procedure attempts to stop the job using an interrupt. However, the job may not be stopped immediately, and the stop job command will have to wait. If this parameter is set to TRUE, then the procedure kills the job slaves. Default is FALSE. |
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.
