Hello,
I keep running into this problem again and again - I create a new chain and execute it.
The job's state in ALL_SCHEDULER_JOBS is "RUNNING", but all chain steps in ALL_SCHEDULER_RUNNING_CHAINS show NOT_STARTED.
I do have a chain rule that just has TRUE as condition, so the first step should definitely be running...
There are no other jobs running, so this should not be a resource issue...
The code is:
DBMS_SCHEDULER.CREATE_PROGRAM('XT_RMP_CSC_MESSAGE_RECEIVED','STORED_PROCEDURE','DN_DWH.SX_RMP_CSC_MESSAGE_RECEIVED',0, TRUE,NULL);
DBMS_SCHEDULER.ENABLE('XT_RMP_CSC_MESSAGE_RECEIVED');
DBMS_SCHEDULER.CREATE_PROGRAM('XT_RMP_EVALUATION_CSC_MESSAGE','STORED_PROCEDURE','DN_DWH.SX_RMP_EVALUATION_CSC_MESSAGE',0, TRUE,NULL);
DBMS_SCHEDULER.ENABLE('XT_RMP_EVALUATION_CSC_MESSAGE');
DBMS_SCHEDULER.CREATE_PROGRAM('XT_RMP_VEHICLE_STATE','STORED_PROCEDURE','DN_DWH.SX_RMP_VEHICLE_STATE',0, TRUE,NULL);
DBMS_SCHEDULER.ENABLE('XT_RMP_VEHICLE_STATE');
DBMS_SCHEDULER.CREATE_CHAIN('YYY', EVALUATION_INTERVAL=>NULL, COMMENTS=>NULL, RULE_SET_NAME=>NULL);
DBMS_SCHEDULER.DEFINE_CHAIN_STEP('YYY', STEP_NAME=>'XT_RMP_EVAL_CSC_MSG', PROGRAM_NAME=>'XT_RMP_EVALUATION_CSC_MESSAGE');
DBMS_SCHEDULER.DEFINE_CHAIN_STEP('YYY', STEP_NAME=>'XT_RMP_VEHICLE_STATE', PROGRAM_NAME=>'XT_RMP_VEHICLE_STATE');
DBMS_SCHEDULER.DEFINE_CHAIN_STEP('YYY', STEP_NAME=>'XT_RMP_CSC_MSG_RECEIVED', PROGRAM_NAME=>'XT_RMP_CSC_MESSAGE_RECEIVED');
DBMS_SCHEDULER.DEFINE_CHAIN_RULE('YYY', 'TRUE', 'START "XT_RMP_CSC_MSG_RECEIVED"', NULL, NULL);
DBMS_SCHEDULER.DEFINE_CHAIN_RULE('YYY', '"XT_RMP_CSC_MSG_RECEIVED" COMPLETED', 'START "XT_RMP_VEHICLE_STATE"', NULL, NULL);
DBMS_SCHEDULER.DEFINE_CHAIN_RULE('YYY', '"XT_RMP_VEHICLE_STATE" COMPLETED', 'START "XT_RMP_EVAL_CSC_MSG"', NULL, NULL);
DBMS_SCHEDULER.DEFINE_CHAIN_RULE('YYY', '"XT_RMP_EVAL_CSC_MSG" COMPLETED', 'END ', NULL, NULL);
DBMS_SCHEDULER.ENABLE('YYY');
What could be wrong here?
I had this problem in the past when I had created the chain using SqlDeveloper, and after creating the same chain again two or three times it worked all of a sudden. But I was never able to figure out the difference between the working chain and the ones that did not work...
Thank you