[Home] [Help] [Dependency Information]
Object Name: | DBA_AUTOTASK_CLIENT_JOB |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Current automated maintenance jobs
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CLIENT_NAME | VARCHAR2 | (64) | Client name | |
JOB_NAME | VARCHAR2 | (65) | Job name | |
JOB_SCHEDULER_STATUS | VARCHAR2 | (15) | Jobs Scheduling Status | |
TASK_NAME | VARCHAR2 | (64) | Program associated with the job | |
TASK_TARGET_TYPE | VARCHAR2 | (64) | Kind of target being processed | |
TASK_TARGET_NAME | VARCHAR2 | (513) | Yes | Name of target |
TASK_PRIORITY | VARCHAR2 | (7) | Task level prority | |
TASK_OPERATION | VARCHAR2 | (64) | Operation name |
Cut, paste (and edit) the following text to query this object:
SELECT CLIENT_NAME
, JOB_NAME
, JOB_SCHEDULER_STATUS
, TASK_NAME
, TASK_TARGET_TYPE
, TASK_TARGET_NAME
, TASK_PRIORITY
, TASK_OPERATION
FROM SYS.DBA_AUTOTASK_CLIENT_JOB;
|
|
|