Stop Job
Go Up to Available object actions by DBMS
This action builds and submits a DBMS_SCHEDULER.STOP_JOB call, letting you stop a job immediately.
Platform Availability
- ORCL 10g ^
To stop a job
- 1. In Rapid SQL, on a connected Oracle datasource, expand the Scheduler nodes and select the Jobs node.
- 2. Right-click a job and select Stop Job from the context menu.
- 3. Use the following table as a guide to understanding and modifying settings in the dialog:
| Step | Settings and tasks | |
|---|---|---|
|
Action options |
Select the Force Stop check box to provide a FORCE attribute value of TRUE forcing the job to terminate immediately. Deselect the Use current session check box to provide a FORCE attribute value of FALSE. | |
|
Dependencies |
Lists referring and referenced objects potentially impacted by the change. For details, see Dependencies. | |
|
Preview |
Displays the DDL that will execute the object action. For details, see Preview. | |
- 4. Click Execute. For information on the scheduling option, see Scheduling.