Database Administration (MOSC)

MOSC Banner

chain jobs not working properly

edited Sep 27, 2013 5:37AM in Database Administration (MOSC) 9 commentsAnswered
 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');

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center