Hi,
For our datawarehouse we have a standard set of small jobs that should be run at the beginning of each workflow. These jobs are combined in a workflow wsetparameters. wsetparameters is offcource defined to allow multiple instances. Also all jobs being called in this workflow are defined as multiple instance.
now when we create a workflow for a dimension this starts by calling this wsetparameters with as invocationid the name of the dimensionflow. How can we pas this in wsetparameters to be also the invocation of the jobs in this flow?
otherwise formulated : can we catch the invocationid the workflow is started with to pass this to the jobs it's running.
I'm not very familiar with the routines and the basic in DS, so if it would involve these things please be very specific in the description (complete example would be very much appreciatied)
forwarding invocationid's to lower level-jobs
Moderators: chulett, rschirm, roy
Thanks for the good words but I am not sure how this is working now. If this is in a batch job or a sequence then it may be a little different. Usually I have a parameter which reflects the invocation id either exactly or logically. When I get row stats then the main invocation id is the job sequence name. From then on it is the dependent job name. It could of been the job sequence name plus 1, 2 , 3 ... All you need to do is control the duplicates.
Mamu Kim