DBMS Scheduler error [message #338776] |
Tue, 05 August 2008 22:49 |
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 #338797 is a reply to message #338783] |
Tue, 05 August 2008 23:40 |
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;
|
|
|