DSXchange

Hey All,

Could any one help me in this requirement pls,
I wanna run a job for each and every row from the input source record, so when i call a job inside a transformer means i can accomplish that. Any one pls help me out in doing this.

Thanks in advance

There is a UtilityRunJob() function that will do that for you. You can search here or in your local documentation for that name to find the syntax, usage examples, etc.

Not positive, but you may need to use a Server job for this... I'm sure someone can confirm/deny.

Hi Craig,

Thanks much for the reply its very useful to find something, but need 1 clarification is that UtilityRunJob() or DSRunJob() , please advice.

No, it's UtilityRunJob. DSRunJob is the function that you'd use in a BASIC job control routine and what a Sequence job uses in the code it generates. You could, of course, write something that leveraged that in a similar manner but why bother when UtilityRunJob does all that automagically for you?

In the 7.x release, you can find it documented in the Server Job Developer's Guide pdf, perhaps elsewhere.

In a parallel job you will need a BASIC Transformer stage - UtilityRunJob() can not be called from a parallel Transformer stage. Or you can use a server job.