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

VIEW: SYS.DBA_AUTOTASK_OPERATION

Object Details
Object Name: DBA_AUTOTASK_OPERATION
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Automated Maintenance Task Operation Configuration

[View Source]

Columns
Name Datatype Length Mandatory Comments
CLIENT_NAME VARCHAR2 (64)
Name of Autotask Client
OPERATION_NAME VARCHAR2 (64)
Name of Autotask Client Operation
OPERATION_TAG VARCHAR2 (3)
Tag of Autotask Client Operation
PRIORITY_OVERRIDE VARCHAR2 (7)
Priority that will be used for all jobs performing the operation
ATTRIBUTES VARCHAR2 (4000)
Operation attributes
USE_RESOURCE_ESTIMATES VARCHAR2 (5)
Specifies if resource usage estimates are used for the operation
STATUS VARCHAR2 (8)
Status of the operation
LAST_CHANGE TIMESTAMP(6) WITH TIME ZONE (13)
Timestamp of the last change
Query Text

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


SELECT CLIENT_NAME
,      OPERATION_NAME
,      OPERATION_TAG
,      PRIORITY_OVERRIDE
,      ATTRIBUTES
,      USE_RESOURCE_ESTIMATES
,      STATUS
,      LAST_CHANGE
FROM SYS.DBA_AUTOTASK_OPERATION;

Dependencies

[top of page]

SYS.DBA_AUTOTASK_OPERATION references the following:

SchemaSYS
PL/SQL PackageDBMS_AUTO_TASK - show dependent code
TableKET$_CLIENT_CONFIG
SYS.DBA_AUTOTASK_OPERATION is referenced by following:

SchemaPUBLIC
SynonymDBA_AUTOTASK_OPERATION
SchemaSYS
Package BodyDBMS_AUTO_TASK_EXPORT - show dependent code