Database Administration (MOSC)

MOSC Banner

Chain Job

edited Jul 17, 2009 2:32AM in Database Administration (MOSC) 3 commentsAnswered
 When I execute the job immediately receive a CHAIN_STALLED in the last run status. Log Info:REASON="manual slave run"


REASON="manual slave run"

This is a job which execute a chain. Here are the rules for the chain.


SCHED_RULE$1 1=1
SCHED_RULE$2 :INVOICE_CDRS.STATE = 'SUCCEEDED'
SCHED_RULE$3 :UPDATE_DTP_RECORDINGS.COMPLETED = 'TRUE'
SCHED_RULE$4 :INVOICE_CDRS.STATE = 'FAILED'

 appreciate if anyone can help on this?

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