How to Parameterize Invocation ID
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 46
- Joined: Tue Aug 21, 2007 5:39 am
- Location: Bangalore, India
How to Parameterize Invocation ID
Hi,
I have a job which loads data based on a user defined SQL into target table. Since this job is called by 2 different sequences which run in parellel, I have checked the "Allow Multiple Instance" checkbox both at job level and sequence level.
When I click on the run button I need to manuall enter Invocation ID. I want this to be parameterized. How can I achieve this?
Thanks
Rajendhar
I have a job which loads data based on a user defined SQL into target table. Since this job is called by 2 different sequences which run in parellel, I have checked the "Allow Multiple Instance" checkbox both at job level and sequence level.
When I click on the run button I need to manuall enter Invocation ID. I want this to be parameterized. How can I achieve this?
Thanks
Rajendhar
Re: How to Parameterize Invocation ID
Hi Rajendhar
If you observer the JobActivity Stage in the sequence, you will find an option called InvocationID. here you can give mention the same, instead of providing the value at run time.
If you observer the JobActivity Stage in the sequence, you will find an option called InvocationID. here you can give mention the same, instead of providing the value at run time.
-
- Participant
- Posts: 46
- Joined: Tue Aug 21, 2007 5:39 am
- Location: Bangalore, India
You can use the job parameter of the sequence and use it for Invocation id. orrajendharreddy wrote:Thanks for your reply.
Iam aware of that option, but my requirment is to parametarize it. Please let me know how can this be achieved.
Regards,
Rajendhar
You can also create User variables and use it for Invocation Id in the job Activity stage.
-
- Participant
- Posts: 46
- Joined: Tue Aug 21, 2007 5:39 am
- Location: Bangalore, India
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
In other words, you simply create and populate the appropriate job parameter and then use it in the Invocation ID box in the Job Activity stage rather than you hard-coded value. This box only appears for MI jobs and you seem to know which that is.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 62
- Joined: Sat Mar 07, 2009 4:59 am
- Location: Chicago
- Contact:
May be invoacation ID is changing everytime
Hi
may i know ur real concern , is this?
that is everytime invocation id is changing and how can we manually give evrytime invocation id ,we wanna automatically i take
this is my solution from my end
just add parameter and give parameter name in job activity and before this value assign in job activity write one funtion to take job invocation id to that parameter ,because i think invocation id changes everytime
is this helpful for u
may i know ur real concern , is this?
that is everytime invocation id is changing and how can we manually give evrytime invocation id ,we wanna automatically i take
this is my solution from my end
just add parameter and give parameter name in job activity and before this value assign in job activity write one funtion to take job invocation id to that parameter ,because i think invocation id changes everytime
is this helpful for u
Suresh Reddy
ETL Developer
Research Operations
"its important to know in which direction we are moving rather than where we are"
ETL Developer
Research Operations
"its important to know in which direction we are moving rather than where we are"
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Professional English - particuarly not "u" and "ur" - is very important on DSXchange. Good English is difficult enough for those whose first language is not English; poor English only makes things harder. Please limit yourself to words that are likely to be found in a language translation dictionary.
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.
-
- Participant
- Posts: 62
- Joined: Sat Mar 07, 2009 4:59 am
- Location: Chicago
- Contact:
Thanks Ray
Thanks For Suggestion
next time before posting i will take care of my words
next time before posting i will take care of my words
Suresh Reddy
ETL Developer
Research Operations
"its important to know in which direction we are moving rather than where we are"
ETL Developer
Research Operations
"its important to know in which direction we are moving rather than where we are"