Access the Oracle Job Scheduler.
A job assigns a task to a schedule. The job tells the schedule which tasks - either one-time tasks created "on the fly," or predefined programs - to run. A specific program can be assigned to one, multiple, or no schedule(s); likewise, a schedule may be connected to one, multiple, or no program(s).
Tab | Description | Oracle |
---|---|---|
Check the status and settings of existing jobs. Create, run, schedule, edit and remove jobs. |
All Oracle releases | |
Programs Tab | Define or select programs to be executed. | Oracle 10g release or later |
Schedules Tab | Define the frequency with which the Scheduler will execute a particular set of tasks. | Oracle 10g release or later |
Windows Tab | Define time windows during which resource plans will be activated. | Oracle 10g release or later |
Window Groups Tab | Create a named group with containing windows with similar scheduling properties for ease of management | Oracle 10g release or later |
Job Classes Tab | Group together jobs that have similar resource demands into job classes to ensure best utilization of resources. | Oracle 10g release or later |
Job Log Tab | Show the current status and information about jobs over a specified date range or by owner. | Oracle 10g release or later |
Window Log Tab | Show the current status and information about Windows over a specified date range. | Oracle 10g release or later |
The Jobs function in the Job Scheduler allows you to create, run or schedule jobs.
Note that some of the functionality below is only available in Oracle 10g or later releases.
Button | Description |
---|---|
New |
Click to create a job. This opens the New Job Wizard:
The new job will appear in the Jobs window. |
Save |
To attach a program, schedule or job class to a job (for 10g or later)
To schedule a job (for 10g or later)
|
Advanced |
Edit available Attribute Values for the selected item (for 10g or later). |
Clone |
Create a copy of the selected item (for 10g or later). |
Run |
To run a job
|
Drop |
Remove the selected item from the database (for 10g or later). |
(Only for Oracle 10g release or later)
A program defines what the Scheduler will execute. A program's attributes include its name, type (for example: a PL/SQL procedure or anonymous block), and the action it is expected to perform. A program can also accept zero to many arguments, which makes it a flexible building block for constructing schemes of tasks to be scheduled.
Button | Description |
---|---|
New |
Click to create a program
|
Save | Save changes to a selected program or a new program. |
Advanced | Edit available Attribute Values for the selected item. |
Drop | Remove the selected item from the database. |
(Only for Oracle 10g release or later)
A schedule defines when and at what frequency the Scheduler will execute a particular set of tasks. A schedule's attributes include the date on which a set of tasks should begin, how often the tasks should be repeated and when the set of tasks should no longer be executed, either as of a specified date and time, or after a specified number of repetitions.
Button | Description |
---|---|
New |
Click to create a schedule
|
Save | Save changes to a selected schedule or a new schedule. |
Advanced | Edit available Attribute Values for the selected item. |
Drop | Remove the selected item from the database. |
© ALL RIGHTS RESERVED. Nutzungsbedingungen Datenschutz Cookie Preference Center