DSXchange

Is there any way to handle exceptions in datastage job sequence? How can I use Exception Handler in my job sequence?

Thank you

Hi,
You can use Expression Type and associate Triggers with them.

Ketfos

Most activities support multiple outputs.

For example, a Job Activity might have three outputs, triggered by "Run OK", "Run with Warnings" and "Otherwise".

You can use Custom triggers anywhere.

The Exception handler is a stand-alone component that is triggered if something goes wrong (read "aborts") anywhere in the job sequence. It's a sledgehammer (some would say "catch all") approach.