[Home] [Help] [Dependency Information]
Object Name: | USER_ILMRESULTS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Information on jobs created for a user
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TASK_ID | NUMBER | Number that uniquely identifies a specific ILM execution | ||
JOB_NAME | VARCHAR2 | (128) | Yes | Job name for executing policies |
JOB_STATE | VARCHAR2 | (35) | State of the Job | |
START_TIME | TIMESTAMP(6) | (11) | Time of start of the job | |
COMPLETION_TIME | TIMESTAMP(6) | (11) | Time of completion of the job | |
COMMENTS | VARCHAR2 | (4000) | More information if the job failed | |
STATISTICS | CLOB | (4000) | ILM job related statistics |
Cut, paste (and edit) the following text to query this object:
SELECT TASK_ID
, JOB_NAME
, JOB_STATE
, START_TIME
, COMPLETION_TIME
, COMMENTS
, STATISTICS
FROM SYS.USER_ILMRESULTS;
|
|
|