UtilityRunJob
Moderators: chulett, rschirm, roy
UtilityRunJob
Where I can to found information about the syntaxis for: UtilityRunJob?
Thanks a lot
Javier
Thanks a lot
Javier
Consultant in DTS
Re: UtilityRunJob
Thansk for your response
But I read the document and continue my problem, this is the sentence:
If usrEnvVariablesDataforMeasure.ValuePAT > 0 then UtilityRunJob
UtilityRunJob('UT00003jControlJob.ControlJobFactAPORILearnerPAT','parameterjobhost=' :'Server':'|parameterjobUser=':'User':'|parameterjobpass=':'key',0,0)
I'm working in datastage vers 7.5 and Windows
Thank
JAvier
But I read the document and continue my problem, this is the sentence:
If usrEnvVariablesDataforMeasure.ValuePAT > 0 then UtilityRunJob
UtilityRunJob('UT00003jControlJob.ControlJobFactAPORILearnerPAT','parameterjobhost=' :'Server':'|parameterjobUser=':'User':'|parameterjobpass=':'key',0,0)
I'm working in datastage vers 7.5 and Windows
Thank
JAvier
Consultant in DTS
My process is:
UserVariablesActivity--->NestedCondition---->JobActivity
In UserVariables I have an SQL ( select A1 from A). The final result I move a (Var1)
In NestedConditon I make one question: UtilityRunJob("Job", Var1> 0, 0, DSJS.RUNFAILED)
In JobActivity (Master Execute Job/ Control Job). My idea is verify that my table contain data.
Thank
Javier
UserVariablesActivity--->NestedCondition---->JobActivity
In UserVariables I have an SQL ( select A1 from A). The final result I move a (Var1)
In NestedConditon I make one question: UtilityRunJob("Job", Var1> 0, 0, DSJS.RUNFAILED)
In JobActivity (Master Execute Job/ Control Job). My idea is verify that my table contain data.
Thank
Javier
Consultant in DTS
Sorry, my specific problem is:
The function UtilityRunJob doesn't understand my parameters,
UtilityRunJob("Job", Var1 > 0, 0, DSJS.RUNFAILED)
I want to verify the value of Var1 (this value comes from SQL's answer) , if Var1 > 0 I want to run the Job, if not I want to receive an error message.
Thanks
Javier
The function UtilityRunJob doesn't understand my parameters,
UtilityRunJob("Job", Var1 > 0, 0, DSJS.RUNFAILED)
I want to verify the value of Var1 (this value comes from SQL's answer) , if Var1 > 0 I want to run the Job, if not I want to receive an error message.
Thanks
Javier
Consultant in DTS
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Run the job from a Job activity. Store the value it retrieves in the job's user status area. Access that value downstream of the Job activity using the $UserStatus activity variable. Make your comparison in a Nested Condition activity to determine whether or not to trigger execution of the other job.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Javieregh wrote:I mean the next step is already a Job Activity. Do you have another idea that I can use?
![Confused :?](./images/smilies/icon_confused.gif)
Your problem is twofold. Not only is UtilityRunJob not appropriate in a Sequence job, you cannot use it in a trigger expression like you seem to be doing. You would use it in a Server job's transformer stage, in a situation where you needed to run a job - over and over - once for every record that flows through the job.
And the triggers evalute expressions. So after the job runs that determines Val1, use the triggers from the Nested Exception stage to decide if it was "> 0" or not and branch accordingly.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers