DATABASE JOB NOTES

 

Jobs

DATABASE JOB NOTES:

Log User - USER who was logged in when the job was submitted.

Schema - Default schema used to parse the job. For example, if the SCHEMA_USER is SCOTT and you submit the procedure HIRE_EMP as a job, Oracle looks for SCOTT.HIRE_EMP.

Job# - Identifier of job. Neither import/export nor repeated executions change it.

Interval - A date function, evaluated at the start of execution, becomes next NEXT_DATE.

Next Execution - Date/time that this job will next be executed.

Broken - If Y, no attempt is made to run this job. See DBMS_JOBQ.BROKEN (JOB).

What - Body of the anonymous PL/SQL block that this job executes.

select  LOG_USER,
 SCHEMA_USER schema,
 JOB job#,
 INTERVAL,
 to_char(NEXT_DATE,'MM/DD/YYYY HH24:MI:SS') next_execution,
 BROKEN,
 substr(WHAT,1,100) what
from  dba_jobs
order  by LOG_USER