Run Job (Oracle Jobs)

Go Up to Available object actions by DBMS

This action builds and submits a DBMS_SCHEDULER.RUN_JOB call, letting you run a job immediately.

Platform Availability

• ORCL 10g ^

To run a job immediately

1. In DBArtisan, on a connected Oracle datasource, expand the Instance and Scheduler nodes and select the Jobs node.

2. Right-click a job and select Run 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 Use current session check box to provide a USE_CURRENT_SESSION attribute value of TRUE. Deselect the Use current session check box to provide a use_current_session 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.