Jobs wizard (Oracle)

From DBArtisan
Jump to: navigation, search

Go Up to Oracle Object Wizards

This wizard builds and submits a call to DBMS_SCHEDULER.CREATE_JOB with optional DBMS_SCHEDULER.SET_JOB_ARGUMENT_VALUE, DBMS_SCHEDULER.SET_ATTRIBUTE, and DBMS_SCHEDULER.ENABLE calls. This lets you create a fully-specified job.

Note: This functionality is available as of Oracle 10g.
Note: Before working with jobs, consult Oracle documentation for general information on DBMS_SCHEDULER. For more information, see Accessing Third Party Documentation.

To create a job using a wizard

1. In DBArtisan, on a connected Oracle datasource, expand the Instance and Scheduler nodes, right-click the Jobs node and select Create from the context menu.
2. Use the following topics as a guide to setting properties and performing tasks as you pass through the wizard panels:
3. Finally, use the Finish button to create the object.

Jobs (Oracle) - Properties

When creating or editing a job, this tab/panel lets you work with the following settings:

Group Settings and Description


Lets you provide an Owner and Name for the job.


Lets you provide Enabled, Description (COMMENTS), and Job Class (JOB_CLASS) attributes.


Lets you select a Schedule Type of IMMEDIATE, ONCE, REPEATING, or specified SCHEDULE. Depending on your selection, the following settings may be available: Repeat Interval - corresponds to a REPEAT_INTERVAL attribute. Calendaring syntax, as described in Oracle DBMS_SCHEDULER documentation, can be typed free-form, and will be passed directly to the server. For information on third-party documentation access, see Accessing Third Party Documentation. Start Date and End Date - correspond to START_DATE and END_DATE, attributes. Schedule Owner and Schedule Name - correspond to SCHEDULE_NAME attribute components.


The Auto Drop setting corresponds to a CREATE_JOB AUTO_DROP attribute. Other settings result in one or more DBMS_SCHEDULER.SET_ATTRIBUTE calls being generated with RESTARTABLE, JOB_PRIORITY, MAX_RUNS, MAX_FAILURES, FAILED RUNS, STOP_ON_WINDOW_CLOSE, INSTANCE_STICKINESS, or JOB_WEIGHT attributes specified, as appropriate.

Jobs (Oracle) - Action

When creating or editing a job, this tab/panel lets you specify a JOB_ACTION attribute for the DBMS_SCHEDULER.CREATE_JOB call, specifying the job action for the job.

To specify a job action

  2. Based on your Job Type selection, provide additional details as follows:
    • PLSQL BLOCK - Type or paste the SQL to be executed.
    • STORED PROCEDURE - Provide the Procedure Owner and Procedure Name.
    • EXECUTEABLE - Use the browse button to locate the executable.
    • PROGRAM - Provide the Program Owner and Program Name.
    • CHAIN - Provide the Chain Owner and Chain Name.

Jobs (Oracle) - Arguments

When creating or editing a job, if you selected an Action tab choice of PROGRAM, EXECUTABLE, or STORED PROCEDURE, this tab/panel lets you manage parameters to be passed.

Note: If you provide arguments with an Action tab choice of PROGRAM, the provided arguments override those specified in the program definition. For details, see Programs wizard (Oracle).