Oracle® Database Administrator's Guide 11g Release 1 (11.1) Part Number B28310-01 |
|
|
View PDF |
Each Scheduler object is a complete database schema object of the form [schema.]name
. Scheduler objects exactly follow the naming rules for database objects and share the SQL namespace with other database objects.
When names for Scheduler objects are used in the DBMS_SCHEDULER
package, SQL naming rules continue to be followed. By default, Scheduler object names are uppercase unless they are surrounded by double quotes. For example, when creating a job, job_name => 'my_job'
is the same as job_name => 'My_Job'
and job_name => 'MY_JOB'
, but not the same as job_name => '"my_job"'
. These naming rules are also followed in those cases where comma-delimited lists of Scheduler object names are used within the DBMS_SCHEDULER
package.
See Oracle Database SQL Language Reference for details regarding naming objects.