Oracle Job Queue Wizard (Oracle)

From RapidSQL
Jump to: navigation, search

Go Up to Oracle Object Wizards

This wizard lets you build and submit a DBMS_JOB.SUBMIT call, creating a once-only or scheduled job, optionally submitted as broken.

To create a new job queue using a wizard:

  1. Open a creation wizard for a job queue. For details, see Opening an Object Wizard.
  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 Execute button to create the object. For more information, see Previewing the DDL Generated to Create the New Object.

Job Queues (Oracle) - Properties

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

Option Availability and Description

No Parse

Specifies the value of the NO_PARSE flag. If deselected, the associated procedure is parsed on submission. If selected, the associated procedure is parsed the first time the job is executed.

Submit as disabled

If selected, the DBMS_JOB.SUBMIT call generated to create the job, is followed by a DBMS_JOB.BROKEN call. Marking the job as broken, this disables the job and in order to execute the job, you must use the Run Job object action. For details, see Run Job (job queues).

Next Date

Use this control to open a calendar that lets you select a date for the job to run with a default time of midnight. You can then modify the time value.

Run Again

Every

Only available if Run Again is selected and Use Custom Expression is not selected..

Time Unit

Use Custom Expression and Custom Expression

Only available if Run Again is selected. Custom Expression becomes available when Use Custom Expression is selected.

Job Queues (Oracle) - Definition

When creating or editing a job, the tab/panel lets you provide the DBMS_JOB.SUBMIT call’s WHAT parameter, specifying the name of the PL/SQL procedure to run.