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 /