chain jobs not working properly
Hi,
BEGIN
DBMS_SCHEDULER.CREATE_PROGRAM (
program_name => 'p1',
program_action => '/home/oracle/p1.sh',
program_type => 'EXECUTABLE',
comments => 'My comments here');
END;
/
BEGIN
DBMS_SCHEDULER.CREATE_PROGRAM (
program_name => 'p2',
program_action => '/home/oracle/p2.sh',
program_type => 'EXECUTABLE',
comments => 'My comments here');
END;
/
BEGIN
DBMS_SCHEDULER.CREATE_CHAIN (
chain_name => 'mychain',
rule_set_name => NULL,
evaluation_interval => NULL,
comments => 'My first chain');
END;
/
BEGIN
DBMS_SCHEDULER.DEFINE_CHAIN_STEP (
chain_name => 'mychain',
step_name => 'step1',
program_name => 'p1');
DBMS_SCHEDULER.DEFINE_CHAIN_STEP (
chain_name => 'mychain',
step_name => 'step2',
program_name => 'p2');
0