Job Editor

Previous  Top  Next

With the Oracle Job Editor, you can create, modify and drop jobs for the Oracle Scheduler.

 

As you cannot give names to Oracle Jobs, the editor will not allow you to enter a name when you create a new job.

 

Oracle Job Editor with a new Job

 

The Broken checkbox shows the user if the job is considered broken by Oracle, this is only available for existing jobs.

 

The Run At tells you when the job should be ran the first time, while Interval allows you to create an expression that returns a valid value for it. When using the drop down button, there's a list of handy shortcuts to create an interval for you.

 

Create an interval for the job

 

When you save the job, Database Workbench will send the job to the Oracle server and return the new job number as it's name. This job number can then be used when modifying or dropping the job.

 

See also: Date and Time Editing