| General Information |
| Source |
$ORACLE_HOME/rdbms/admin/dbmsatsk.sql |
| First Available |
11.1.0.6 |
| 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 |
| Subprograms |
|
| |
| 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 |
