I have similar requirement as explained in this link.
I did the same procedure for passing one run time value as parameter for 'where' clause the job 2.
Steps followed:
a. Created a routine "GetDate" with Arg1 and with code "Ans = Arg1"
b. Created Job-1 to fetch the Data value from table. Created a stage variable UserStatus and assigned GetDate(FieldName).
c. Created Job-2 with parameter (BeginDate) for date.
d. Created sequence with two job activities.
e. At job_activity2, mapped Job_Activity1.$UserStatus to BeginDate.
Individually, Job 1 & 2 runs fine. The routine also gives the argument as reply.
Issue:
When sequence is ran, BeginDate is getting empty value
![Sad :(](./images/smilies/icon_sad.gif)
Please let me know if I made any mistake in the process. This is an urgent requirement.
Thanks,
dxk9