oracle create chain step

Solutions on MaxInterview for oracle create chain step by the best coders in the world

showing results for - "oracle create chain step"
Lukas
18 Jun 2019
1BEGIN
2DBMS_SCHEDULER.DEFINE_CHAIN_STEP (
3   chain_name      =>  'my_chain1',
4   step_name       =>  'my_step1',
5   program_name    =>  'my_program1');
6DBMS_SCHEDULER.DEFINE_CHAIN_STEP (
7   chain_name      =>  'my_chain1',
8   step_name       =>  'my_step2',
9   program_name    =>  'my_chain2');
10END;
Eden
12 Oct 2020
1BEGIN
2DBMS_SCHEDULER.CREATE_CHAIN (
3   chain_name          => 'my_chain1',
4   rule_set_name       => NULL,
5   evaluation_interval => NULL,
6   comments            => 'My first chain');
7END;