[Home] [Help] [Dependency Information]
Object Name: | AD_JOBS_DEFERRED |
---|---|
Object Type: | TABLE |
Owner: | APPLSYS |
FND Design Data: | AD.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
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AD_JOBS_DEFERRED_U1 | NORMAL | UNIQUE | APPS_TS_INTERFACE |
SESSION_ID
PHASE FILE_PRODUCT SUBDIRECTORY FILENAME ARGUMENTS |
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 |
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;
APPLSYS.AD_JOBS_DEFERRED does not reference any database object
APPLSYS.AD_JOBS_DEFERRED is referenced by following:
|
|
|