Job Queue Editor (Oracle)
Go Up to [[Oracle Object Editors{{#if:||{{{2}}}}}]]
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
- Open an editor on the job queue. For details, see Opening an Object Editor.
- Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
| Tab | Settings and tasks |
|---|---|
|
Properties |
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. |
|
Definition |
This tab lets you modify the DBMS_JOB.SUBMIT call’s WHAT parameter, specifying the name of the PL/SQL procedure to run. |
|
DDL |
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.
