Page 2 of 2
Posted: Fri Jan 09, 2009 6:45 am
by ds_search2008
Len to be honest its very much hard to understand the code under job properties dialog box. Could you please suggest me a simple option to trace the problem.
Thank you
Posted: Fri Jan 09, 2009 8:24 am
by chulett
ds_search2008 wrote:The Sequencer mode is set to "Any" only. I have check it. However I'm receiving SeqActJobs..JobControl (@Coordinator): Note: Sequencer 'Sequencer' was entered, but never exited log message.
As noted, the
only time you should get a message like that is for an "All" Sequencer where not all input links "fired". I fear we're missing something quite fundamental here as everything you've posted now looks fine and doesn't explain why two jobs run rather than one and why you're seeing this log message.
Posted: Fri Jan 09, 2009 8:25 am
by chulett
ds_search2008 wrote:Len to be honest its very much hard to understand the code under job properties dialog box. Could you please suggest me a simple option to trace the problem.
He didn't ask you to understand it, he ask you to
post it so *he* can see what was generated.
Posted: Tue Jan 13, 2009 10:17 am
by LenGreenwood
Yep, post the code or a DSX & I can probably interpret it for you.
Only way to trace this sort of thing, that I can think of, would be to put Routine stages into the sequence between other stages, using calls to UtilityMessageToLog to log messages containing the actual values of various job variables or expressions. For example, calling UtilityMessageToLog with an argument that has the value of the expression:
Code: Select all
Convert(@FM,"",EXC_Read_Seq_AcCode.$CommandOutput)
just before it gets to the job activity that runs the "CA" job wold be instructive I think.
Posted: Tue Jan 13, 2009 10:36 am
by savis
ds_search2008 wrote:
I checked the Execute command activity
Triggers
Name: ACTCD_CA
Expression Type: Custom(conditional)
Expression: Convert(@FM,"",EXC_Read_Seq_AcCode.$CommandOutput) = 'CA'
Name: ACTCD_SA
Expression Type: Custom(conditional)
Expression: Convert(@FM,"",EXC_Read_Seq_AcCode.$CommandOutput) = 'SA'
Name: ACTCD_OA
Expression Type: Custom(conditional)
Expression: Convert(@FM,"",EXC_Read_Seq_AcCode.$CommandOutput) = 'OA'
All the three job activities--->Triggers tab
output link names --Expression type are set to - OK - (Conditional)
I'm not sure why savingsaccount job is running in parallel.
Can you try the below code in your trigger expression?
Name: ACTCD_CA
Expression Type: Custom(conditional)
Expression: If <Execute_Command_label>.$CommandOutput Matches "CA" Then 1 Else 0
Name: ACTCD_SA
Expression Type: Custom(conditional)
Expression:If <Execute_Command_label>.$CommandOutput Matches "SA" Then 1 Else 0
Name: ACTCD_OA
Expression Type: Custom(conditional)
Expression: If <Execute_Command_label>.$CommandOutput Matches "OA" Then 1 Else 0
Gurus,
Please correct me if I am wrong
Thanks,
Savis
Posted: Tue Jan 13, 2009 10:41 am
by chulett
Well, there's really no need for the "else" in the expresion and "matches" with no wildcards is the same as an equality check, so...