Oracle | DBMS_AUTOTASK

Oracle DBMS_AUTOTASK_PRVT Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

Purpose Internal support for Auto Task jobs

AUTHID DEFINER

Data Types TASKLISTTYPE

Dependencies

DBMS_AUTOTASK_PRVT_LIB	DBMS_SWAT_ARM_INTERNAL	DBMS_SWAT_VER_INTERNAL
DBMS_AUTO_TASK_IMMEDIATE	DBMS_SWAT_MM_INTERNAL	KET$_CLIENT_TASKS
DBMS_STANDARD

Documented No

First Available Not known

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/prvtatsk.plb

Subprograms

ABA	GET_TASKS	RUN_AUTOTASK
ABORT_AUTOTASK	REFRESH_CLIENT_CONFIG	SETUP
AGE	REQUEST_GRACE_PERIOD

ABA

Undocumented dbms_autotask_prvt.aba;

exec dbms_autotask_prvt.aba;

ABORT_AUTOTASK

Aborts an executing autotask dbms_autotask_prvt.abort_autotask(task_id IN BINARY_INTEGER);

exec dbms_autotask_prvt.abort_autotask(163);

AGE

Undocumented dbms_autotask_prvt.age;

exec dbms_autotask_prvt.age;

GET_TASKS

Undocumented dbms_autotask_prvt.get_tasks(client_id IN BINARY_INTEGER) RETURN sys.dbms_autotask_prvt.tasklisttype

TBD;

REFRESH_CLIENT_CONFIG

Refresh client autotask configuration dbms_autotask_prvt.refresh_client_config;

exec dbms_autotask_prvt.refresh_client_config;

      

      PL/SQL procedure successfully completed.

REQUEST_GRACE_PERIOD (new 21c)

Undocumented dbms_autotask_prvt.request_grace_period RETURN NUMBER;

SELECT dbms_autotask_prvt.request_grace_period

      FROM dual;

      

      REQUEST_GRACE_PERIOD

      --------------------

                         1

RUN_AUTOTASK

Start autotask execution dbms_autotask_prvt.run_autotask(task_id IN BINARY_INTEGER);

exec dbms_autotask_prvt.run_autotask(163);

SETUP

Undocumented dbms_autotask_prvt.setup(window_group_sync_level IN BINARY_INTEGER);

exec dbms_autotask_prvt.setup(0);

      exec dbms_autotask_prvt.setup(3);