Wednesday, June 3, 2009

DBA_SCHEDULER data dictionary tables

DBA_SCHEDULER data dictionary tables

Table Name Description


DBA_OBJECTS ------------------------------------ All objects in the database
DBA_SCHEDULER_PROGRAMS---------------All scheduler programs in the database
DBA_SCHEDULER_JOBS----------------------- All scheduler jobs in the database
DBA_SCHEDULER_JOB_CLASSES---------- All scheduler classes in the database
DBA_SCHEDULER_WINDOWS-------------- All scheduler windows in the database
DBA_SCHEDULER_PROGRAM_ARGS----- All arguments of all scheduler programs in the database
DBA_SCHEDULER_JOB_ARGS--------------- All arguments with set values of all scheduler jobs in the
database
DBA_SCHEDULER_JOB_LOG------------------Logged information for all scheduler jobs
DBA_SCHEDULER_JOB_RUN_DETAILS--- The details of a job run
DBA_SCHEDULER_WINDOW_LOG---------- Logged information for all scheduler windows
DBA_SCHEDULER_WINDOW_DETAILS---- The details of a window
DBA_SCHEDULER_WINDOW_GROUPS----- All scheduler window groups in the database


Table Name Description


DBA_SCHEDULER_WINGROUP_MEMBERS-------- Members of all scheduler window groups in the database
DBA_SCHEDULER_SCHEDULES----------- --------All schedules in the database
DBA_SCHEDULER_GLOBAL_ATTRIBUTE------ All scheduler global attributes
DBA_SCHEDULER_CHAINS-------------------------- All scheduler chains in the database
DBA_SCHEDULER_CHAIN_RULES----------------- All rules from scheduler chains in the database
DBA_SCHEDULER_CHAIN_STEPS------------------ All steps of scheduler chains in the database
DBA_SCHEDULER_RUNNING_CHAINS------------ All steps of all running chains in the database

No comments:

Post a Comment

Followers

About Me

My photo
N.Delhi, Delhi, India
I am an Oracle Certified Professional, Oracle 9i/10G DBA, having 4+ years of core DBA experience.