Show Job Class Information
--
-- Shows Job Calss 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
/

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License