Oracle DBMS_AUTO_TASK
Version 23c

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 Undocumented support utility for Auto Task administration
AUTHID Definer
Data Types TYPE window_calendar_entry IS RECORD (
window_name dba_scheduler_windows.window_name%TYPE,
start_time  TIMESTAMP WITH TIME ZONE,
duration    dba_scheduler_windows.duration%TYPE);

TYPE window_calendar_t IS TABLE OF window_calendar_entry;

TYPE winname_t IS RECORD (
window_name dba_scheduler_windows.window_name%TYPE,
start_date  TIMESTAMP WITH TIME ZONE,
end_date    TIMESTAMP WITH TIME ZONE);

TYPE refcur_winname_t IS REF CURSOR RETURN winname_t;
Dependencies
DBA_AUTOTASK_CLIENT DBA_AUTOTASK_SCHEDULE DBMS_AUTOTASK_PRVT_LIB
DBA_AUTOTASK_CLIENT_JOB DBA_AUTOTASK_TASK DBMS_SCHEDULER
DBA_AUTOTASK_JOB_HISTORY DBA_AUTOTASK_WINDOW_CLIENTS DBMS_STANDARD
DBA_AUTOTASK_OPERATION DBA_SCHEDULER_WINDOWS KET$_WINDOW_LIST
Documented Yes
First Available 11.1
Pragmas PRAGMA SUPPLEMENTAL_LOG_DATA(default, NONE);
Security Model Owned by SYS with EXECUTE granted to PUBLIC
Source $ORACLE_HOME/rdbms/admin/dbmsatsk.sql
Subprograms
 
CHECK_ASYNC_OPERATION_STATUS (new 23c)
Check for asynchronous operation request status dbms_auto_task.check_async_operation_status(request_id IN NUMBER) RETURN VARCHAR2;
PRAGMA SUPPLEMENTAL_LOG_DATA(check_async_operation_status, READ_ONLY);
TBD
 
CHECK_CLIENT_STATUS_OVERRIDE
Signal an error if the client is overridden to DISABLED even if it is enabled on disk dbms_auto_task.check_client_status_override(client_id IN PLS_INTEGER);
TBD
 
DECODE_ATTRIBUTES
Decode attribute flags into a string for display dbms_auto_task.decode_attributes(attr IN NUMBER DEFAULT 0) RETURN VARCHAR2;
SELECT dbms_auto_task.decode_attributes(28)
FROM dual;

DBMS_AUTO_TASK.DECODE_ATTRIBUTES(28)
--------------------------------------------------
LIGHT, STABLE, VOLATILE


SELECT dbms_auto_task.decode_attributes(99)
FROM dual;

DBMS_AUTO_TASK.DECODE_ATTRIBUTES(99)
--------------------------------------------------
ONCE PER WINDOW, HEAVY, DO NOT KILL, SAFE TO KILL
 
GET_ASYNC_OPERATION_OUTPUT (new 23c)
Return the output of an asynchronous operation request dbms_auto_task.check_async_operation_output(request_id IN NUMBER) RETURN CLOB;
PRAGMA SUPPLEMENTAL_LOG_DATA(get_async_operation_output, READ_ONLY);
TBD
 
GET_CLIENT_STATUS_OVERRIDE
Determines if a client's status should be overridden to DISABLED even if it is ENABLED on disk dbms_auto_task.get_client_status_override(client_id IN PLS_INTEGER)RETURN PLS_INTEGER;
TBD
 
GET_SCHEDULE_DATE
Compute a list of the task scheduled date provide the start and end dates. taskname is the defined autotask name (used by EM) dbms_auto_task.get_schedule_date(
taskname       IN  VARCHAR2,
start_date     IN  TIMESTAMP WITH TIME ZONE,
end_date       IN  TIMESTAMP WITH TIME ZONE,
scheduled_list OUT ket$_window_list);
desc ket$_window_list
 
RECONCILE_ATTRIBUTES
Combines supplied attribute flag sets into a single set of attribute flags. Arguments listed in order of descending priority. I.e. ask_rep_attr settings, if any, override all of the other settings. dbms_auto_task.reconcile_attributes(
cli_comp_attr  IN NUMBER DEFAULT 0, -- client compile-time attributes
cli_rep_attr   IN NUMBER DEFAULT 0, -- client repository attributes
op_comp_attr   IN NUMBER DEFAULT 0, -- operation compile-time attributes
op_rep_attr    IN NUMBER DEFAULT 0, -- operation repository attributes
task_comp_attr IN NUMBER DEFAULT 0, -- task client-defined attributes
task_rep_attr  IN NUMBER DEFAULT 0) -- task repository override attributes
RETURN NUMBER;
TBD
 
WINDOW_CALENDAR
Undocumented dbms_auto_task.window_calendar(w IN refcur_winname_t) RETURN window_calendar_t PIPELINED;
TBD

Related Topics
Built-in Functions
Built-in Packages
DBMS_AUTOTASK_PRVT
DBMS_AUTO_TASK_ADMIN
DBMS_AUTO_TASK_EXPORT
DBMS_AUTO_TASK_IMMEDIATE
DBMS_RESOURCE_MANAGER
DBMS_RESOURCE_MANAGER_PRIVS
What's New In 21c
What's New In 23c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2023 Daniel A. Morgan All Rights Reserved
  DBSecWorx