44 lines
1.0 KiB
SQL
44 lines
1.0 KiB
SQL
@@header
|
|
|
|
/*
|
|
*
|
|
* Author : Vishal Gupta
|
|
* Purpose : Display Auto Tasks
|
|
* Compatibility :
|
|
* Parameters : NONE
|
|
*
|
|
* Revision History:
|
|
* ===================
|
|
* Date Author Description
|
|
* --------- ------------ -----------------------------------------
|
|
* 28-Jun-16 Vishal Gupta Created
|
|
*
|
|
*/
|
|
|
|
|
|
PROMPT **************************************************
|
|
PROMPT * Database Auto Tasks
|
|
PROMPT **************************************************
|
|
|
|
|
|
COLUMN client_name HEADING "Client Name" FORMAT a35
|
|
COLUMN client_tag HEADING "Client|Tag" FORMAT a6
|
|
COLUMN window_group HEADING "Scheduler|Window|Group" FORMAT a15
|
|
COLUMN resource_percentage HEADING "Res(%)" FORMAT 99999
|
|
|
|
|
|
|
|
SELECT a.client_name
|
|
, a.status
|
|
, a.consumer_group
|
|
, a.client_tag
|
|
, a.priority_override
|
|
, a.window_group
|
|
, a.resource_percentage
|
|
, a.service_name
|
|
, a.
|
|
FROM dba_autotask_client a
|
|
;
|
|
|
|
@@footer
|