Dbms_scheduler and Dbms_job

Quote Original: http://foolraty.iteye.com/blog/1107803

For dbms_job usage:
To find out more information about this failing job you can simply go over the jobnumber and select the needed information From the view dba_jobs.

Sql>select job, what from Dba_jobs;

For Dbms_scheduler usage:
For the application user the usage of scheduled jobs are now more defined by the name of the job and not by the job identif Ier.
Unfortunal the error message ORA-12012 won't show you the name of the job, but would still show you the job identifier.
This job identifier are now more dictionary information and correlates to the object_id from the view dba_objects

The job identifier is stored in the table sys.scheduler$_job under Column obj#.

When a relation for the job identifier to the job name was needed then the following SELECT statement can help:

Select obj#, object_name from Sys.scheduler$_job, dba_objects
where obj# = object_id;

Dbms_scheduler and Dbms_job