regarding uservariable activity

vijaykumar · Post by **vijaykumar** » Tue Jan 02, 2007 5:00 pm

Hi gurus,
i want to use variables in sequence.
so used USER VARIABLE ACTIVITY.Actually i want to declare a variable called status and assign it value .
if status =1 then job1 else job2.
user variable activity---->jobactivity1---->jobactivity2.
is my design correct, plz help me and how can i declare this variable.
plz help me.

cheers;
vijay

narasimha · Post by **narasimha** » Tue Jan 02, 2007 5:05 pm

You dont need to define this extra variable 'status'.
You can make use of the return value of the UserStatus in your condition
Example
if JOBA.$UserStatus = 1 then job1 else job2

kumar_s · Post by **kumar_s** » Tue Jan 02, 2007 5:06 pm

You can use Nested contition Activity next to User Variable Activity and branch both the Job Activity stage based on different condition.

ray.wurlod · Post by **ray.wurlod** » Tue Jan 02, 2007 5:25 pm

In case you still want to use a User Variables activity, be aware that it has the wierdest grid control - it's completely blank when opened (no grid). You have to right-click and choose Add New Row.

That's how you declare a variable in a User Variables activity. Fill in the variable name and its derivation expression once you've created the new row for it.

vijaykumar · Post by **vijaykumar** » Tue Jan 02, 2007 5:44 pm

Hi Gurus,
thanks very much.iam only using nested condition.
iam going by this design.
nested condition--->jobactivity1---->jobactivity2.
in the nested condition i have choosen expression type as CUSTOM-(CONDITIONAL)
i have declared expression as if job1.$userstatus=1 then job1 else job2.
while validating expression iam getting error as EXPECTED EXPRESSION.
plz help me in validating expression and is my design correct am i going in the right way.

cheers;
vijay

narasimha · Post by **narasimha** » Tue Jan 02, 2007 5:49 pm

Use these in your expressions in the Nested Condition Activity

Code: Select all

- job1.$userstatus=1 (for jobactivity1)
- Otherwise (for jobactivity2)

You should be good.

narasimha · Post by **narasimha** » Tue Jan 02, 2007 5:52 pm

Oh, Your need to change your job design. Use this (Check the expression values from my previous post)

Code: Select all

NestedConditionActivity------>jobactivity1
                    |
                    |
                    |-------->jobactivity2

Instead of using

Code: Select all

nested condition--->jobactivity1---->jobactivity2

vijaykumar · Post by **vijaykumar** » Tue Jan 02, 2007 6:51 pm

HI GURUS,
THANKS VERY MUCH.
actually when i used 'job1.$userstatus=1' i could validate the expression, but when i see the director log, its simply running the job2, it checking job2 initially, its saying since the result status is 1 finished executing job.

is that the expected result, actually it should also run job1 and should check the status i think, plz help me if iam wrong.

cheers;
saama

kumar_s · Post by **kumar_s** » Tue Jan 02, 2007 7:04 pm

Are you checking the log for the Sequence or for the Job2? Is the log for the Job2 shows its running?

vijaykumar · Post by **vijaykumar** » Tue Jan 02, 2007 7:10 pm

HI GURUS,
i have given sequence a name like job4.
this is what iam able to view from the log of this job.
JOB4 -> (job2): Job run requested
Mode (row/warn limits) = 0/0
Job Parameters --->
DSJobController=JOB4.
this is what iam getting. why is it not checking JOB1, its simply starting job2.

cheers;
vijay

narasimha · Post by **narasimha** » Tue Jan 02, 2007 8:23 pm

vijaykumar wrote:actually when i used 'job1.$userstatus=1' i could validate the expression, but when i see the director log, its simply running the job2, it checking job2 initially, its saying since the result status is 1 finished executing job.

There must be something wrong with how you are setting your UserStatus in your job.

chulett · Post by **chulett** » Tue Jan 02, 2007 9:38 pm

Narasimha, what makes you think that UserStatus is involved in any of this?

All Vijay ever said was:

i want to use variables in sequence. so used USER VARIABLE ACTIVITY.Actually i want to declare a variable called status and assign it value .

User Variables stage. A variable called status. Then you sidetracked everything with an assumption of 'User Status'. At least it seems like you got the links properly separated, now we just need to know how this 'status' variable is getting set so the last of this can get straightened out as well.

Vijay, you need to explain a little more clearer where the value of this status variable is getting set... and how you want to use it to control the execution of these two jobs.

narasimha · Post by **narasimha** » Tue Jan 02, 2007 11:24 pm

Oops... My bad....Sorry about that Vijay.
Thanks for correcting me Craig.

If I understood it right this time, your new design could be.

Code: Select all

UserVariablesActivity------->NestedConditionActivity------>jobactivity1
                                  |
                                  |
                                  |----------------------->jobactivity2

Conditions in your NestedConditionActivity would be

Code: Select all

Expression Type           Expression
------------------       -------------
Custom - (Conditional)    UserVariablesActivity.Status=1
Otherwise                 N/A

As Craig said, you need a way to set the value for 'status'.
How do you want to set a value for this variable?

ray.wurlod · Post by **ray.wurlod** » Wed Jan 03, 2007 12:01 am

I wouldn't be at all surprised if the OP requires $JobStatus.

chulett · Post by **chulett** » Wed Jan 03, 2007 7:41 am

I was wondering the exact same thing, if all we were talking about was a normal 'OK (Conditional)' trigger...