Passing multiple values in a global variable

dataservices job design
1

Hi,

I have a scenario where i need to schedule a job by passing multiple values for the same global variable.

For example, I need to schedule JOB_1 with $GV_STATE and pass values like ‘Arizona’, ‘California’, ‘Texas’ etc… either the job has to run for each state multiple times or one time passing one state after other.

Please share your inputs.

Thanks

kevinjohnson19 (BOB member since 2011-12-07)

2

If you pass multiple values then there will have to be code inside the job that parses the list and runs objects multiple times, once for each item in the list, or passing the list on to each object for use within a dynamic IN expression.

Or, you could schedule the job once for each value. This may be the easiest method, but it depends on how the job is written.

eganjp :us: (BOB member since 2007-09-12)