Calling a Job in transformer

jeraj4k6 · Post by **jeraj4k6** » Mon Jan 10, 2011 8:19 pm

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

chulett · Post by **chulett** » Mon Jan 10, 2011 8:28 pm

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.

jeraj4k6 · Post by **jeraj4k6** » Mon Jan 10, 2011 8:45 pm

Hi Craig,

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

chulett · Post by **chulett** » Mon Jan 10, 2011 9:05 pm

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.

ray.wurlod · Post by **ray.wurlod** » Mon Jan 10, 2011 11:07 pm

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.