DSXchange

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

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.

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

rajendharreddy 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 use the job parameter of the sequence and use it for Invocation id. or
You can also create User variables and use it for Invocation Id in the job Activity stage.

How can this be done? Can you please quote an example?

What do YOU mean by parameterizing? How do you intend it to change for each run ?

Hi Rajendhar,
Add some parameter (say INVOCATION_ID) to the job parameters of the Job Sequence. Go to the required job activity stage and browse for Invocation Id, there you will be able to find all the job parameters. Select the required one (INVOCATION_ID).

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.

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

Thanks For Suggestion
next time before posting i will take care of my words