eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: SYS.DBA_AUTOTASK_CLIENT_JOB

Object Details

Object Name:	DBA_AUTOTASK_CLIENT_JOB
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

Current automated maintenance jobs

[View Source]

Columns

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

Query Text

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;

Dependencies

[top of page]

SYS.DBA_AUTOTASK_CLIENT_JOB references the following:

SYS: DBA_SCHEDULER_JOBS; DBMS_SCHEDULER - show dependent code; KET$_CLIENT_TASKS

SYS.DBA_AUTOTASK_CLIENT_JOB is referenced by following:

PUBLIC: DBA_AUTOTASK_CLIENT_JOB