TODO
Event-based jobs.
«batch of jobs»
An event schedule starts a job when a certain event is detected.
The condition that determines if an event is raised is formulated in the syntax of an advanced queuing rule. (See also dbms_aqadm.add_subscriber)
A
file watcher is a scheduler object that defines file properties. If a file arrives that meets the specified properties, the scheduler starts a job.
Definable file properties include
- location (i.e. a directory object)
- file name (wildcards:
? and *)
- minimum file size
Definition of incompabilities (create_incompatibility). See also Using Incompatibilites in Oracle's Database Adminstration Guide.
Also in the Db Admin Guide:
- Creating and dropping a resource
- Scheduler Chain Condition Syntax
- Detached jobs
A job class allows to group jobs for resource allocation and prioritazation.
Groups allow to apply the effect of a dbms_scheduler procedure to all members of the group.
There are three types of groups:
- window groups
- database destination groups
- external destination groups
A window allows to automatically activate different resource plans at different times.
create_job vs create_program
External destinations create_database_destination, drop_agent_destination etc.
select *
from
dba_directories
where
directory_name = 'SCHEDULER$_LOG_DIR';
Agents (which must be registered with the database before the database can submit jobs to the agent).
The MANAGE SCHEDULER privilege.