how to use exception handler in seequence

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
GSSaru
Participant
Posts: 7
Joined: Wed Aug 31, 2005 12:04 am
Contact:

how to use exception handler in seequence

Post by GSSaru »

Hi all...

Can anybody tell how t o use exception handler activity in seequence.
And what is the main purpose of it?
and is it link to the job activity,which handles the aborted job?
and i am seeing only general tab in its properties....is it right???

thanks and regards
GS saravanan
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

What exact version of DataStage?

You do not link to it from any object, but rather it stands alone and waits for Something Bad to happen. In earlier versions, that 'something bad' was exceptions in the Sequence job itself - job wasn't runnable, bad parameter names, etc.

In 7.5.x it can handle all exceptions. For example, if a Job Activity only has an 'OK' trigger and finishes in a non-OK status, control will transfer to the Exception Handler.

In either case, you can then handle the exception - send emails, abort the job, whatever. The stage should have a 'Help' button. It is also dicussed in the pdf documentation installed with your client.
-craig

"You can never have too many knives" -- Logan Nine Fingers
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

If any activity aborts in the JobSequence, the control comes to the ExceptionActivity stage and its consicutive stage for action. As Craig mentioned you can use to contorl to notify or alert.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
sengs
Participant
Posts: 55
Joined: Thu Nov 24, 2005 12:51 am

Re: how to use exception handler in seequence

Post by sengs »

GSSaru wrote:Hi all...

Can anybody tell how t o use exception handler activity in seequence.
And what is the main purpose of it?
and is it link to the job activity,which handles the aborted job?
and i am seeing only general tab in its properties....is it right???

thanks and regards
GS saravanan
When some stage in a Sequence aborts or throws some warning you can use the exception handler and a notification activity to trigger mails.It will have only the general tab and it will not have any triggers.
Serach with the string as exception handler you have all answers to your questions
Post Reply