DSXchange

Hello Everyone,

Good afternoon,

Goal: Invoking a child server job n no of times at the same time in parallel.

Scenario: 8 files should be processed into the same staging table. Using the sequencers the job can be invoked using diff parameters ( say load1.... load 8 ) at the same time, but 8 diff sequence stages used.

Flow
Parameter file no of load=8 --> 8 diff sequence stages --> Invoke the same server job with diff parameter.

Is there a way we can invoke the same job using single sequence stage at the same time.
Parameter file no of load=8 --> single sequence stages --> Invoke the same server job with diff parameter.

Thanks

You must compile the job as multi-instance capable (a check box in the job properties page). As you start each instance you give a different invocation ID. This is the approved, and only, mechanism for running clones of the same job at the same time.

As you note, the file name will need to be passed as a parameter, and the job instances must not break any rules, such as all trying to write to the same text file.

And please be aware, depending on the processing power required for the job, just because you CAN start eight at a time, doesn't mean you SHOULD start eight at a time.

Trying to submit too many jobs simultaneously on an over-stressed system can cause DSJE_TIMEOUT errors.

I put a workaround by calling Unix command to call the job in loop.

What happened to your "in parallel" requirement?

ray.wurlod wrote:What happened to your "in parallel" requirement? ...

Sorry for the late response Ray. The unix scripts interval is so quick and we dint have to run the jobs in parallel.