Scribd
Upload
15 views1 page

191 Split Oracle

The document describes the basic workflow for using the Oracle Scheduler. It involves creating programs, schedules, and jobs. Creating programs is optional but allows actions to be reused across multiple jobs. Schedules define when jobs should run. Jobs are then created and submitted using the defined programs and schedules.

Uploaded by

agnesmonalisa11
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
15 views1 page

191 Split Oracle

The document describes the basic workflow for using the Oracle Scheduler. It involves creating programs, schedules, and jobs. Creating programs is optional but allows actions to be reused across multiple jobs. Schedules define when jobs should run. Jobs are then created and submitted using the defined programs and schedules.

Uploaded by

agnesmonalisa11
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Your Basic Work Flow

To simplify management tasks with the Scheduler:


1. Create a program (enabled or disabled)—optional
- To reuse this action within multiple jobs
- To change the schedule for a job without having to
re-create the PL/SQL block

Oracle University and Egabi Solutions. use only


2. Create and use a schedule.
3. Create and submit a job.

Copyright © 2009, Oracle. All rights reserved.

Your Basic Work Flow


You can perform all steps either in the graphical environment of Enterprise Manager or by using the
DBMS_SCHEDULER PL/SQL package via the command line.
1. Creating a Program
Use the CREATE_PROGRAM procedure to create a program. Creating a program is an optional part
of using the Scheduler. You can also encode the action to be performed within an anonymous
PL/SQL block in the CREATE_JOB procedure. By creating the program separately, you can define
the action once, and then reuse this action within multiple jobs. This enables you to change the
schedule for a job without having to re-create the PL/SQL block.
A program is created in a disabled state by default (unless the enabled parameter is set to TRUE).
A disabled program cannot be executed by a job until it is enabled. You can specify that a program
should be created in the enabled state by specifying a value of TRUE for enabled.
2. Creating and Using Schedules
The schedule for a job can be a predefined schedule (created with the CREATE_SCHEDULE
procedure) or defined as part of the job creation.

THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM ONLY. COPYING eKIT MATERIALS FROM THIS
COMPUTER IS STRICTLY PROHIBITED
Oracle Database 11g: Administration Workshop II 17 - 5

You might also like