List Scheduler info

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