Oracle | DBMS_AUTO

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

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