DSXchange

Posted: **Wed Mar 19, 2008 8:16 am**

Hi,

I am trying to abort the job on the basis of 1 condition. If that condition is not satisfied, the job should get aborted.

EX: If 'SQLcode' column value is not equal to 0 then job should get aborted.

Can anyone suggest the solution for this??

Posted: **Wed Mar 19, 2008 10:00 am**

Dont you have a option in Transformer with 'Abort after n rows'?
Pass the record with the above mentioned condition to that newly link. And include the Option that I specified as well for 1 record.

Posted: **Wed Mar 19, 2008 4:59 pm**

Is this, indeed, a Transformation Extender (TX) job?

Posted: **Thu Mar 20, 2008 3:06 am**

If it is TX use the FAIL function.

DSXchange

Manual abort of a job

Manual abort of a job