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.
KeywordsShell Script UNIX System Rapper Script Correct Confi Exit Code
Unable to display preview. Download preview PDF.