@@header

/*
*
*  Author        : Vishal Gupta
*  Purpose       : Display Auto Tasks
*  Compatibility : 
*  Parameters    : NONE
*
*  Revision History:
*  ===================
*  Date       Author        Description
*  ---------  ------------  -----------------------------------------
*  28-Jun-16  Vishal Gupta  Created
*
*/


PROMPT **************************************************
PROMPT * DB 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
  FROM dba_autotask_client a
;  

@@footer