I'm trying to pass a runtime parameter to a job which holds a value from a previous one. i.e. selecting max(date) from job1 then passing the result in where clause of job2.
After searching, I've followed the following scenario:
viewtopic.php?t=132137&highlight=overwr ... eter+value
Job design is:chulett wrote:Not directlyTypically, that '1st ODBC' work would be in one job and the results would be landed somewhere, say in USERSTATUS. Then a Sequence job would read the value from user status and assign it to a Job Parameter in a second job where the '2nd ODBC' would use it in its where clause.
Code: Select all
Job1_Activity --> UserVariableActivity --> Job2_Activity
1- Create a server routine called 'DSSetUserStatus' to set the value of $UserStaus variable:
Code: Select all
Call DSSetUserStatus(Arg1)
Ans =Arg1
Code: Select all
DSSetUserStatus(max_date)
4-Now the $UserStatus variable should hold the max_date value.
My questions:
1- At job1_Activity, what is the required expression for 'UserStatus' expression?
2- At UserVariableActivity, after adding a new row what's the expected expression also?
Sorry for long post.
Regards.
[/code]