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 action format a30


select owner,chain_name,step_name,program_name 
from dba_scheduler_chain_steps
where owner like upper('%&1%') and chain_name like upper('%&2%')
order by 1,2;

select owner,chain_name,rule_name,condition,action 
from DBA_SCHEDULER_CHAIN_RULES
where owner like upper('%&1%') and chain_name like upper('%&2%')
order by 1,2,3,4;


undefine &&1
undefine schema

undefine &&2
undefine jobn