Switching between sequence and job

chulett · Post by **chulett** » Wed Jun 11, 2008 6:29 am

Wow... now I'm being compared to Rube Goldberg. Cool - I love that guy! :D

Minhajuddin wrote:Moreover the OP has not mentioned that the data to be processed is mutually exclusive.

That was the impression I got from this part of his requirements:

mydsworld wrote:Now based on each record column value, I need to call different jobs say J2,J3 etc in the sequence MySeq.

Not only do they seem to be mutually exclusive but it seems (based on the followup questions) the record values would need to be passed in as job parameters, once per invocation. Hence the (actually rather simple) advice I gave. Our dsworld may need to come back and clarify his requirements, it seems.

And in case any of you younger whipper-snappers aren't familiar with Rube, he made a name for himself by designing overly complex ways to solve simple problems. For example:

Minhajuddin · Post by **Minhajuddin** » Wed Jun 11, 2008 6:52 am

Hey Craig, I meant no offense. I respect you a LOT. I guess there is just a misunderstanding about the requirement.

Nice picture by the by :D

mydsworld · Post by **mydsworld** » Wed Jun 11, 2008 7:21 am

Thanks for all the posts.

Will try them out. By the way, is there any limit of size for using 'USERSTATUS'. Because if I need to store delimited values in it,it may become too lengthy.

chulett · Post by **chulett** » Wed Jun 11, 2008 7:24 am

While I'm sure there is a limit, I sincerely doubt you will run afoul of it.

mydsworld · Post by **mydsworld** » Wed Jun 11, 2008 9:09 am

I Have my sequence S1 :
J1 -> J2

In J1, BASIC transformer, I am forming stage variable (by concatenating fields) and calling my server routine that uses DSSetUserStatus() to set USERSTATUS equal to stage variable.

Back in S1,I am calling J2 with J1.$Userstatus as job parameter.But I am getting no value in that parameter in J2.

Minhajuddin · Post by **Minhajuddin** » Wed Jun 11, 2008 9:41 am

Just to figure out where the problem is:

echo J1.$UserStatus using an execute command activity and see if you are user status is being set correctly in job J1

mydsworld · Post by **mydsworld** » Wed Jun 11, 2008 9:59 am

The Userstatus is not being set from J1 correctly.What could be the problem.Can I not set Userstatus in parallel job using server routine that calls DSSetUserStatus()

mydsworld · Post by **mydsworld** » Wed Jun 11, 2008 10:11 am

The Userstatus is not being set from J1 correctly.What could be the problem.Can I not set Userstatus in parallel job using server routine that calls DSSetUserStatus()