40 lines
1.1 KiB
MySQL
40 lines
1.1 KiB
MySQL
|
@@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
|