Chapter 1 -
Overview of Oracle Job Scheduling
||Oracle Tips by Burleson
Scheduled Tasks Wizard
Clicking the Next button produces a list of programs that can
be scheduled as shown in Figure 1.3. If the program or script that
is desired is not available in the list, the Browse button
allows the user to select alternatives from the file system.
Figure 1.3 – Scheduled Tasks Wizard:
Once the relevant command or script is
selected, clicking the Next button displays a screen that
allows a name and basic schedule to be associated with the task as
shown in Figure 1.4.
Figure 1.4 – Scheduled Tasks Wizard: name
and basic schedule
The contents of the next screen vary depending
on the type of basic schedule selected. Figure 1.5 shows the
additional schedule information that can be defined for a daily
Figure 1.5 – Scheduled Tasks Wizard:
additional scheduling options
The next screen, Figure 1.6, permits
authorization credentials for the task to be assigned, allowing the
task to run as any valid operating system user. It is important
that tasks run with the correct credentials, as running tasks under
privileged accounts can introduce potential security holes.
Figure 1.6 – Scheduled Tasks Wizard:
||Need an Oracle Health Check?
Does your boss blame you for an Oracle performance problem?
Need to prove that your database is properly optimized?
BC Oracle performance guru's can quickly verify every aspect of your
Oracle database and provide a complete certification that your database
is fully optimized.