How to abort job based on constraint

ray.wurlod · Post by **ray.wurlod** » Fri Dec 08, 2006 4:23 pm

Create another output link from the Transformer. Its constraint is the logical inverse of the constraint you have been using. On this link set Abort After Rows to 1. The link can connect to a Copy stage with no output. This will consume the row if it gets that far.

Nageshsunkoji · Post by **Nageshsunkoji** » Fri Dec 08, 2006 6:38 pm

ray.wurlod wrote:Create another output link from the Transformer. Its constraint is the logical inverse of the constraint you have been using. On this link set Abort After Rows to 1. The link can connect to a Copy ...

Hi Ray,

Its a good idea to capture the rows to another link and abort the job.

Here my doubt is if it has only one row, what will be the position, is it aborts the job ?

I have one more requirement like abort the job based on constrtaint and set a customised fatal error in the log (like job aborted because of a not equal to b ), in this scenarios what will we have to do ? is there any built in function to do this ? or we have to use any logice for that ?

Thanks.

ray.wurlod · Post by **ray.wurlod** » Fri Dec 08, 2006 9:22 pm

Try it and see.

(One row does abort the job. But don't take my word for it - a test job would take less than two minutes to create.)

Your additional requirement is not part of the original question, but could easily by solved by creating a column derivation or even constraint expression on the second output link that included a call to DSLogFatal().

As you may have read elsewhere, I do not believe in jobs aborting under any circumstances. Then, when they do, it has to be an environmental factor, such as database not available. Even then, you can test for that with an innocuous job before starting the real work.

chalasaniamith · Post by **chalasaniamith** » Fri Dec 08, 2006 9:24 pm

right couple of mins for test job thanks ray for you time

Nageshsunkoji · Post by **Nageshsunkoji** » Sat Dec 09, 2006 3:47 am

Hi Ray,

Thanks for your valuable suggestions. I will try what ever you said and let dsxians know the result of my job.

Thanks once again.

chalasaniamith · Post by **chalasaniamith** » Mon Dec 11, 2006 1:16 pm

Thanks for every one splly to Ray...

It was resolved by keeping the copy stage from transformer and the option for the link abort after rows worked excellent and its aborting the job.

file-> tx->file
|
copystage->file

thanks