how to abort a parallel job

Gius · Post by **Gius** » Thu Apr 28, 2016 3:49 am

Hello,
We need to create a parallel job that when a query retrieves rows, the job aborts.

Something like a source (with an inside query) then if the query retrieves some records, the job aborts.

thank you -

qt_ky · Post by **qt_ky** » Thu Apr 28, 2016 6:05 am

Follow your query with a Transformer stage. Open up its output link constraint properties and set the "Abort After Rows" value.

chulett · Post by **chulett** » Thu Apr 28, 2016 6:14 am

Another possibility, again from a transformer, would be to leverage the DSLogFatal function based on your triggering condition. Bonus is you can also log the reason why you are aborting it.

Or is that not possible from a Parallel transformer?

ray.wurlod · Post by **ray.wurlod** » Thu Apr 28, 2016 5:46 pm

@Craig It's not possible from a parallel Transformer, but it is possible from a BASIC Transformer stage.

chulett · Post by **chulett** » Thu Apr 28, 2016 9:09 pm

But of course! Stick with the original suggestion.