Scheduler Information
-- -- List scheduler information -- SET PAUSE ON SET PAUSE 'Press Return to Continue' SET HEADING ON SET LINESIZE 300 SET PAGESIZE 60 COLUMN owner FORMAT A10 COLUMN program_name FORMAT A25 COLUMN program_action FORMAT A40 COLUMN comments FORMAT A20 COLUMN number_of_arguments FORMAT 99 SELECT owner, program_name, program_type, program_action, number_of_arguments, enabled, comments FROM dba_scheduler_programs ORDER BY owner, program_name /
