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