Enable/Disable (Oracle Jobs)

From DBArtisan
Jump to: navigation, search

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

To enable or disable a job or program

1. In DBArtisan, on a connected Oracle datasource, expand the Instance and 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.


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.