set lines 200
set pages 3000
set ver off

SET FEEDBACK   OFF
SET DEFINE   On
DEFINE schema = ''
COLUMN schema_val NOPRINT NEW_VALUE schema
SELECT '&&1' schema_val FROM dual;

DEFINE jobn = ''
COLUMN jobn_val NOPRINT NEW_VALUE jobn
SELECT '&&2' jobn_val FROM dual;

column owner format a15
column job_name format a30
column PROGRAM_NAME format a30
column condition format a30
column program_action format a60


select owner,program_name,program_type,program_action,enabled 
from dba_scheduler_programs
where owner like upper('%&1')
and program_name like upper('%&2')
order by owner,program_name;


undefine &&1
undefine schema

undefine &&2
undefine jobn
