Home » RDBMS Server » Server Administration » DBMS Scheduler error (Ora 10 G R2 Windows 2003)
DBMS Scheduler error [message #338776] Tue, 05 August 2008 22:49 Go to next message
amul
Messages: 252
Registered: April 2001
Location: Chennai
Senior Member

Hi,

When i try to run the scheduler create program, getting the following error, please advice.

Error at line 1
ORA-24155: rule MODEL.REBPRO_VALIDATE_DATA_RULE not in rule set MODEL.SCHED_RULESET$2
ORA-06512: at "SYS.DBMS_ISCHED", line 3719
ORA-06512: at "SYS.DBMS_ISCHED", line 1198
ORA-06512: at "SYS.DBMS_SCHEDULER", line 1257
ORA-06512: at line 234
Re: DBMS Scheduler error [message #338783 is a reply to message #338776] Tue, 05 August 2008 23:08 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow Posting Guideline as stated in URL above

Why do expect assistance in debugging code which you did not post?
icon2.gif  Re: DBMS Scheduler error [message #338797 is a reply to message #338783] Tue, 05 August 2008 23:40 Go to previous message
amul
Messages: 252
Registered: April 2001
Location: Chennai
Senior Member
i am sorry, i thought this error was a common one, when i run the following code, its throwing this error

BEGIN
DBMS_SCHEDULER.DEFINE_CHAIN_RULE (
   chain_name   => 'REBPRO_REBATES_PROJECT_CHN',
   condition    => 'TRUE',
   action       => 'START REBPRO_VALIDATE_STEP',
   rule_name    => 'REBPRO_VALIDATE_DATA_RULE',
   comments     => 'FIRST STEP IN REBATE PROJECTION');
end;
Previous Topic: JDK Upgrade from 1.4.2_08 to 1.4.2_13 on oracle 10.2.0.2
Next Topic: db_block_size
Goto Forum:
  


Current Time: Mon Jul 08 15:33:31 CDT 2024