Stop Job

From RapidSQL
Jump to: navigation, search

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

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.


Lists referring and referenced objects potentially impacted by the change. For details, see Dependencies.


Displays the DDL that will execute the object action. For details, see Preview.

4. Click Execute. For information on the scheduling option, see Scheduling.