Oracle | DBMS_AUTOTASK

Oracle DBMS_AUTOTASK_PRVT Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

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);