Enable/Disable (Oracle Jobs)
Go Up to Available object actions by DBMS
This action builds and submits a DBMS_SCHEDULER.DISABLE or DBMS_SCHEDULER.ENABLE call, letting you enable or disable a job or program.
Platform Availability
- ORCL 10g ^
To enable or disable a job or program
- 1. In Rapid SQL, on a connected Oracle datasource, expand the Scheduler nodes and select the Jobs or Programs node.
- 2. Right-click a job or program and select Enable/Disable 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 Enabled check box to enable the job or program. Leave the Enabled check box deselected to disable the job or program. | |
|
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.