I have a multiple instance Sequencer S1 that has 3 jobs J1, J2 and J3 in it. How do i pass the invocation Id that was used when launching the S1 as a Parameter to jobs J1, J2 and J3.
Thanks
Pass Invocation ID as a param to a job.
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 13
- Joined: Tue Nov 08, 2005 9:43 am
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
There is a special macro DSJobInvocationID that can be used in any multiple instance job just like a job parameter. It's likely that if you sequence is multiple instance than your J1, J2 and J3 jobs will be as well so when you pass them an invocation ID you can use DSJobInvocationID and inside the parallel/server job you can use #DSJobInvocationID# anywhere that a job parameter is accepted such as transformers, file paths and file names and database user-defined SQL.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
-
- Participant
- Posts: 13
- Joined: Tue Nov 08, 2005 9:43 am
In Sequencer S1 before i call jobs J1, J2 and J3 i have a routine that i use to lookup the parameters from a file for jobs J1, J2 and J3. In my Job parameters i use <<Routine Name>>.$ReturnValue to get the value of the param returned from the routine.
I need the Instance number as an argument for the routine to lookup the correct param. When i use #DSJobInvocationId# as an argument to the routine it does not substitute it with the invocation ID that was used to lauch the sequencer.
I need the Instance number as an argument for the routine to lookup the correct param. When i use #DSJobInvocationId# as an argument to the routine it does not substitute it with the invocation ID that was used to lauch the sequencer.
-
- Participant
- Posts: 13
- Joined: Tue Nov 08, 2005 9:43 am