--

-- 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

/