Search notes:

Oracle Scheduler

The scheduler is used schedule jobs and tasks.
In order to use the scheduler, the necessary scheduler objects must be created.

TODO

Event-based jobs.
Difference between a job and a program.
«batch of jobs»
SCHEDULER$_EVENT_QUEUE and SCHEDULER_FILEWATCHER_Q (all_int_dequeue_queues, all_dequeue_queues).
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
Definition of incompatibilities (create_incompatibility). See also Using Incompatibilites in Oracle's Database Adminstration Guide.
Also in the DB Admin Guide:
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:
A window allows to automatically activate different resource plans at different times.
Chains
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.
$ORACLE_HOME/rdbms/admin/catmwin.sql

See also

The scheduler's calendaring syntax.
The CJQ0 and Jnnn background processes.
dbms_scheduler
schagent.conf is the configuration file for the Oracle Scheduler agent (see also the $ORACLE_HOME/bin/schagent executable).
Scheduler events

Index

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1740452887, '18.220.140.29', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/adminstration/scheduler/index(129): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78