Accessing Server job variable value from sequence job

[esuyanti]

Hi All,

I need to be able to access a variable value set in a server job from the job sequence that called the server job.

Any idea how I can achive this?

Thank you.

Cheers,

Elly

[kumar_s]

Iam not much clear with your requirment.
Do you need to access the value of the variable (parameter) set in the job sequence and pass it to underlying job?
Or do you need to access the value of the parameter set in the job to the job sequence which calls it?
Or do you need to access a value of stage variable set in a job by a job sequence?

[esuyanti]

Hi,

I have a job sequence that executes 2 server jobs in sequence (execute JobA and then execute JobB).
JobA transformer set a variable(not parameter) called "rej_reason".
I want to be able to access "rej_reason" value from the job sequence after JobA has been executed (i.e pass the "rej_reason" value to JobB).


Thanks

Cheers,

Elly

Iam not much clear with your requirment.
Do you need to access the value of the variable (parameter) set in the job sequence and pass it to underlying job?
Or do you need to access the value of the parameter set in the job to the job sequence which calls it?
Or do you need to access a value of stage variable set in a job by a job sequence?

[ArndW]

Unfortunately variables in jobs only exist while the job is running, i.e. they are not persistant. You can use a call to DSSetUserStatus({value}) in the job and then retrieve it in the parent sequence using DSGetJobInfo({JobHandle},DSJ.USERSTATUS)

[ray.wurlod]

Probably using

Code: Select all

DSGetParamInfo(hJob, ParamName, DSJ.PARAMVALUE) 

[esuyanti]

Can I call DSSetUserStatus(value) from the server job transformer stage? If so, how? Because I tried to use it in stage variable and it gives me error message.

Thanks alot.

Cheer,
Elly

Unfortunately variables in jobs only exist while the job is running, i.e. they are not persistant. You can use a call to DSSetUserStatus({value}) in the job and then retrieve it in the parent s ...

[ArndW]

Yes, you can call it from a transform stage. You will not want to execute this for every row, though. Either in a before/after stage call or as a one time call in the initial value of a stage variable, depending upon how you get the value. The call is a function so it needs to be on the assignment side of a stage variable.

[esuyanti]

Thanks..