Windows Tab
(Only for Oracle 10g release or later)
Assign resource plans to activate at different times such as during specific peak or off-peak periods.
|
New |
Click to create a window
- Enter a Window Name
- Select a Resource Plan from the drop-down list
- Select a Priority from the drop-down list
- Select a Schedule to attach to run during the window as appropriate
- Select the Duration (days, hours, months) for the window
- Specify a start date/time and end date/time for the window
- Select a repeat interval if desired
Click Save.
The new window will appear in the Windows list above.
Click Enabled to activate the window. |
| Save |
Save changes to a selected window or a new window. |
| Advanced |
Edit available Attribute Values for the selected item. |
| Open |
Activate the selected Window and commence running the scheduled jobs based on the durations currently entered. You can change the duration values if required. |
| Close |
Stop the currently active window. Any jobs using that window as their schedule which were started at the beginning of this window and have indicated that they must be stopped on closing of the window will be stopped. |
| Drop |
Remove the selected item from the database. |
Window Groups Tab
(Only for Oracle 10g release or later)
Create a named windows group to which you can assign any number of previously created windows on the Windows Tab
|
New |
Click to create a window group
- Enter a Group Name
- Enter any Comments relevant to that windows group
Click Save.
The new group name will appear in the Window Group Name list on the left-hand side.
Select those Windows listed in the right pane that you want included in the group.
Click Enabled to activate the window group . |
| Save |
Save the window group. |
| Drop |
Remove the selected item from the database. |
Job Classes Tab
(Only for Oracle 10g release or later)
The Scheduler provides the capability to group together jobs that have similar resource demands into job classes. A job class can be used to ensure all jobs within it utilize the same job class attributes, execute at a higher or lower priority than other jobs in other job classes and only allow jobs in the job class to start if there are sufficient resources available.
|
New |
Click create a job class
- Enter a Job Class Name.
- Select the appropriate Resource Consumer Group as defined for the database.
- Select the appropriate Service as defined for the database.
- Select a Logging Level for the database.
- Select the number of days the Log History will be retained.
- Enter any required Comments
Click Save. |
| Save |
Save the job class. |
| Advanced |
Edit available Attribute Values for the selected item. |
| Drop |
Remove the selected item from the database. |
Job Log Tab
(Only for Oracle 10g release or later)
You can view a history of the Job Scheduler transactions over a range of dates, including all job owners if desired.
| From date / To date |
Select the Start and End date range to view. |
| Owner |
Select job owner to use in log display. |
| Refresh |
Update the display. |
