Job Queue Editor (Oracle)

From DBArtisan
Jump to: navigation, search

Go Up to Oracle Object Editors

The Job Queue Editor lets you change the sql procedure specified for the job as well as manage the job’s schedule and status.

To edit a job queue

  1. Open an editor on the job queue. For details, see Opening an Object Editor.
  2. Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
Tab Settings and tasks


Lets you modify the Submit as disabled, Next Date, Run Again, Every, Time Unit, Use Custom Expression, and Custom Expression properties. For details on these properties, see Job Queues (Oracle) - Properties. This tab also displays the following properties: Job - the unique identifier assigned when the job was created. User - the user who submitted the job. Schema User - the user schema for which to parse the job Priv User - the user whose privileges the job is to run under.


This tab lets you modify the DBMS_JOB.SUBMIT call’s WHAT parameter, specifying the name of the PL/SQL procedure to run.


For details on using this tab, see Viewing the SQL/DDL for an Object.

3. When finished, you can submit your changes. For details, see Previewing and Submitting Object Editor Changes.