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