DBA Data[Home] [Help] [Dependency Information]

TABLE: APPLSYS.AD_JOBS_DEFERRED

Object Details
Object Name: AD_JOBS_DEFERRED
Object Type: TABLE
Owner: APPLSYS
FND Design Data: TableAD.AD_JOBS_DEFERRED
Subobject Name:
Status: VALID


Hold jobs which failed during a patching session and are being deferred until the end of the phase to run again


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AD_JOBS_DEFERRED_U1 NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnSESSION_ID
ColumnPHASE
ColumnFILE_PRODUCT
ColumnSUBDIRECTORY
ColumnFILENAME
ColumnARGUMENTS
Columns
Name Datatype Length Mandatory Comments
SESSION_ID NUMBER
Yes Session_id of the session owning the deferred job
PHASE NUMBER
Yes Phase the deferred Job resides in
FILE_PRODUCT VARCHAR2 (10) Yes Product owner
SUBDIRECTORY VARCHAR2 (256) Yes Directory the file resides in
FILENAME VARCHAR2 (256) Yes Name of deferred job filename
ARGUMENTS VARCHAR2 (1996)
Arguments passed to file
START_TIME DATE

Time job started running (for first worker it ran on)
RESTART_TIME DATE

Time job started running (forlast worker it ran on)
ELAPSED_TIME NUMBER

Total runtime for job
RESTART_COUNT NUMBER

Numer of times job was (manually) restarted
DEFER_COUNT NUMBER

Number of times job was deferred
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SESSION_ID
,      PHASE
,      FILE_PRODUCT
,      SUBDIRECTORY
,      FILENAME
,      ARGUMENTS
,      START_TIME
,      RESTART_TIME
,      ELAPSED_TIME
,      RESTART_COUNT
,      DEFER_COUNT
FROM APPLSYS.AD_JOBS_DEFERRED;

Dependencies

[top of page]

APPLSYS.AD_JOBS_DEFERRED does not reference any database object

APPLSYS.AD_JOBS_DEFERRED is referenced by following:

SchemaAPPLSYS
ViewAD_JOBS_DEFERRED#