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