CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 Search the Reference Library pages:  

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

Oracle DBMS_AUTO_TASK
Version 11.1
 
General
Source $ORACLE_HOME/rdbms/admin/dbmsatsk.sql
First Available 11.1

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_SCHEDULER_WINDOWS
DBA_AUTOTASK_OPERATION DBMS_AUTOTASK_PRVT_LIB
DBA_AUTOTASK_SCHEDULE DBMS_SCHEDULER
DBA_AUTOTASK_TASK KET$_WINDOW_LIST
DBA_AUTOTASK_WINDOW_CLIENTS  
Security Model Execute is granted to PUBLIC
 
CHECK_CLIENT_STATUS_OVERRIDE
Signal an error if the client is overridden to DISABLED even if it is 
enabled on disk (e.g. pack disabled, underscore parameter, etc). Called to validate an ENABLE operation.
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;
TBD
 
GET_CLIENT_STATUS_OVERRIDE
Determine if a given client's status should be overridden to DISABLED
even if it is ENABLED on disk (e.g. pack disabled, underscore parameter, etc). A return value of 1 means such an override exists, 0 means it does not.
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

TBD
 
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 attr.
op_rep_attr    IN NUMBER DEFAULT 0, -- operation repository attr.
task_comp_attr IN NUMBER DEFAULT 0, -- task client-defined attr.
task_rep_attr  IN NUMBER DEFAULT 0) -- task repository override attr. 
RETURN NUMBER;
TBD
 
WINDOW_CALENDAR
Undocumented dbms_auto_task.window_calendar(w IN refcur_winname_t)
RETURN window_calendar_t PIPELINED;
TBD
 

Related Topics

DBMS_AUTO_TASK_ADMIN

DBMS_AUTO_TASK_EXPORT

DBMS_AUTO_TASK_IMMEDIATE

DBMS_AUTO_TASK_EXPORT

DBMS_RESOURCE_MANAGER

DBMS_RESOURCE_MANAGER_PRIVS

 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [317 users online]    © 2010 psoug.org