Oracle | DBMS_AUTO

Oracle DBMS_AUTO_TASK Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

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	GET_ASYNC_OPERATION_OUTPUT	RECONCILE_ATTRIBUTES
CHECK_CLIENT_STATUS_OVERRIDE	GET_CLIENT_STATUS_OVERRIDE	WINDOW_CALENDAR
DECODE_ATTRIBUTES	GET_SCHEDULE_DATE

CHECK_ASYNC_OPERATION_STATUS (new 23ai)

Check for asynchronous operation request status dbms_auto_task.check_async_operation_status(request_id IN NUMBER) RETURN VARCHAR2;

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

      

      DBMS_AUTO_TASK.DECODE_ATTRIBUTES(28)

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

      LIGHT, STABLE, VOLATILE

      

      SELECT dbms_auto_task.decode_attributes(99);

      

      DBMS_AUTO_TASK.DECODE_ATTRIBUTES(99)

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

      ONCE PER WINDOW, HEAVY, DO NOT KILL, SAFE TO KILL

GET_ASYNC_OPERATION_OUTPUT (new 23ai)

Return the output of an asynchronous operation request dbms_auto_task.check_async_operation_output(request_id IN NUMBER) RETURN CLOB;

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