Search notes:

Oracle: Jobs

A job is the fundamental scheduler object.
A job stores the information needed to run the task that the job describes. This information includes
A job has an owner: the schema in which it was created.
All jobs of a database can be viewed in dba_jobs, the running ones in dba_jobs_running.
A job is created with dbms_scheduler.create_job, multiple jobs can be created with dbms_scheduler.create_jobs.

Types

There are different job types:
Type Notes
PL/SQL Block An anonymous PL/SQL block. No arguments.
Stored procedure A PL/SQL or Java stored procedure, or a C «subprogram»
Executable Any program that can be run on a command line (i.e. outside of an Oracle process).
Chain The job executes a chain. No arguments supported.
External script A script that is executed in a shell (Unix/Linux) or in cmd.exe (Windows).
SQL Script A script that is executed in or by SQL*Plus.
Backup Script A script that is executed by RMAN

Attribute AUTO_DROP

Each job has the boolean attribute AUTO_DROP which specifies if Oracle drops the job object when the object has completed.
By default, this value is true.

See also

A job might use a username-password pairs to authenticate itself. Such pairs are stored in credential objects.
The value of the init parameter job_queue_processes defines the maximum number of processes that can be created for the execution of jobs.
Programs and job classes.
A job is sometimes related to a program.
dbms_scheduler
Database objects

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...', 1741087546, '18.191.212.181', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/objects/jobs/index(92): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78