Are you overwhelmed with scheduling jobs? Does your administration have Server Access, or are they challenged with scheduling jobs without the needed access? With Oracle Scheduler, you can create, run, and manage jobs. Many types of jobs can be scheduled to run in a frequent manner depending on the time chosen. You can run jobs on a weekly, daily, monthly, yearly or real time. There is a wide array of jobs that can be created. All the jobs need a prior creation of the underlying task they are to be processing.
A couple of examples:
- Any kind of business rule must be created before the job can be scheduled (refresh, clear, aggregation, etc…)
- Data/Metadata import/export jobs must be created before the job can be scheduled. Any import (export) will be read (pushed) to the Inbox/outbox under Overview -> Actions -> Inbox/Outbox explorer
- Application mappings must be created before using Cube map function to move data from one plan type to another which is found under “Data Maps”
- Valid intersections reports job must be created under Application -> Setup before this type of job can be created
Good news is that all the job creations are easy to build as they are on the same user inter-phase under “Application”
This demonstration will provide an example of creating a refresh database job and scheduling it to run on the same time on a daily bases.
Watch the demonstration!
Read the full blog!
Click on the “Jobs” button. This is where you will schedule your job. However you want to create it before you schedule it. To do that I will go to ”Overview” as shown below.
Click on the “Actions” -> “Refresh Database” buttons.
Create the refresh Job using the “Create” button
I left the default options as they are since I want my active users to stay logged on before and after the refresh.
Choose the name of the job so you are able to select it from the job scheduler.
Click the “Refresh” button to show the job you have just created. This refreshes the user inter-phase to update and show newly created jobs.
After refreshing “Close” the inter-phase and go back to the “Jobs” section.
The highlighted areas are the options that I have changed.
Final step is to choose your predefined job as shown below. Next->Finish
Now you can see your job scheduled in the pending jobs section.
Blog post by Yousef Saead of Key Performance Ideas.