40 lines
1.1 KiB
SQL
40 lines
1.1 KiB
SQL
@@header
|
|
|
|
/*
|
|
*
|
|
* Author : Vishal Gupta
|
|
* Purpose : Display DBMS Scheduler Window Groups
|
|
* Compatibility :
|
|
* Parameters : NONE
|
|
*
|
|
* Revision History:
|
|
* ===================
|
|
* Date Author Description
|
|
* --------- ------------ -----------------------------------------
|
|
* 29-Jun-16 Vishal Gupta Created
|
|
*
|
|
*/
|
|
|
|
|
|
PROMPT **************************************************
|
|
PROMPT * DBMS Scheduler Window Groups
|
|
PROMPT **************************************************
|
|
|
|
COLUMN window_group_name HEADING "Window|Group" FORMAT a25
|
|
COLUMN enabled HEADING "Enabled" FORMAT a7
|
|
COLUMN number_of_windows HEADING "No|of|Win" FORMAT 999
|
|
COLUMN next_start_date HEADING "NextStartDate" FORMAT a18 TRUNC
|
|
COLUMN comments HEADING "Comments" FORMAT a60 TRUNC
|
|
|
|
|
|
SELECT wg.window_group_name
|
|
, wg.enabled
|
|
, wg.number_of_windows
|
|
, wg.next_start_date
|
|
, wg.comments
|
|
FROM dba_scheduler_window_groups wg
|
|
ORDER BY wg.next_start_date
|
|
;
|
|
|
|
@@footer
|