TOAD is not generating the correct script for Oracle scheduler chain. This is the complete code to create a Oracle 11g Scheduler chain.
BEGIN
SYS.DBMS_SCHEDULER.CREATE_CHAIN (
chain_name => ‘CHAIN_2’
,rule_set_name => NULL
,evaluation_interval => NULL
,comments => NULL);
SYS.DBMS_SCHEDULER.DEFINE_CHAIN_STEP (
chain_name => ‘CHAIN_2’
,step_name => ‘STEP_A’
,program_name => ‘SCHED_PROG_A’);
SYS.DBMS_SCHEDULER.DEFINE_CHAIN_RULE (
chain_name => ‘CHAIN_2’
,condition => ‘:STEP_A.state = ‘‘SUCCEEDED’’’
,action => 'END ’
,rule_name => ‘END_OF_CHAIN2’
,comments => NULL);
SYS.DBMS_SCHEDULER.DEFINE_CHAIN_RULE (
chain_name => ‘CHAIN_2’
,condition => ‘TRUE’
,action => ‘START STEP_A’
,rule_name => ‘START_OF_CHAIN2’
,comments => NULL);
END;
/
In my script, the word SUCCEEDED has 2 single quotes on left side and 3 single quotes on right side but the script created by TOAD has 1 single quote on left side and 2 single quotes on right side. (‘SUCCEEDED’’ instead of ‘‘SUCCEEDED’’’)