Show Job Class info

--
-- Shows Job Class Info 
--
 
SET PAUSE ON
SET PAUSE 'Press Return to Continue'
SET HEADING ON
SET LINESIZE 300
SET PAGESIZE 60
COLUMN service FORMAT A25
COLUMN comments FORMAT A40
 
SELECT job_class_name,
resource_consumer_group,
service,
logging_level,
log_history,
comments
FROM   dba_scheduler_job_classes
ORDER BY job_class_name
/