listOfBackupWindowDates (by Backup Window ID)

Retrieve Backup Windows (Defined in the Portal) with a Backup Window ID:

FUNCTION listOfBackupWindowDates(
startDate,
finishDate,
windowGroupIDIN apt_date_window.windows_group_id%TYPE)

Based on the backup window definition, the above function returns a list of the adjusted start and finish dates.

The following examples provide a basic idea of the function. These queries should serve as only an example of how the function might be incorporated into a more sophisticated query.

In a SQL Template Designer query, first determine the Backup Window IDs:

select window_group_id, window_group_name from apt_v_date_window

Then, use the Backup Window ID (window_group_id value from above example) in the following query:

select * from TABLE(rtd.listOfBackupWindowDates(TO_DATE('01012010','MMDDYYYY'), to_DATE('01072010','MMDDYYYY'), 100011 ))