Abstract
The database scheduler is an advanced job scheduling capability built into Oracle10g and subsequent releases. The package DBMS_SCHEDULER is the interface to the job scheduler. It is extensively documented in the Oracle Database Administrator’s Guide and the PL/SQL Packages and Types Reference. The database scheduler supports jobs that run inside the DBMS as well as jobs that run outside of the DBMS at operating system level. The latter type of job is termed an external job. Important aspects concerning the execution of external jobs, such as exit code handling, removal of environment variables, details of program argument passing, requirements to run external programs owned by users other than SYS, and default privileges of external jobs defined by the configuration file externaljob.ora are undocumented.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2009 Norbert Debes
About this chapter
Cite this chapter
Debes, N. (2009). DBMS_Scheduler. In: Secrets of the Oracle Database. Apress. https://doi.org/10.1007/978-1-4302-1953-8_19
Download citation
DOI: https://doi.org/10.1007/978-1-4302-1953-8_19
Publisher Name: Apress
Print ISBN: 978-1-4302-1952-1
Online ISBN: 978-1-4302-1953-8
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books