Aborting job for a paticular input

[harryhome]

Hi

I want to abort the job , when from a paticular column a paticular value comes.


This job is a part of a sequence , i can also affort to increase on job after this to abort the job for particular value.

Plz guide me for the same.

[ArndW]

One method is to put a condition in your transform stage variable

Code: Select all

IF [column contains a specific value] THEN UtilityAbortToLog('Oh no, Mr. Bill') ELSE ''

[gateleys]

Hi

I want to abort the job , when from a paticular column a paticular value comes.

Just curious, can you share some example values and reason why you would want to abort the job in their occurrence?

gateleys

[chulett]

I'd be curious as well, but can pass along why we've done something similar across our project.

We have certain lookups of 'core' reference data, the kind that should never fail. On the off chance one does fail, there's no reason to carry on and process anything else, no reason to be subtle about it - with something very similar to what Arnd posted, the job kills itself.

[gateleys]

We have certain lookups of 'core' reference data, the kind that should never fail. On the off chance one does fail, there's no reason to carry on and process anything else, no reason to be subtle about it - with something very similar to what Arnd posted, the job kills itself.

Oh yes. In my case, similar situations are handled at the sequence level, and using Terminator to abort it if required. Of course, using UtilityAbortToLog in the Transformer is simpler.

gateleys