Exception Handler

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
sowmyadevi
Participant
Posts: 10
Joined: Mon Apr 05, 2004 8:24 am

Exception Handler

Post by sowmyadevi »

Hi,

How could i use Exception Handler and explain with best
Example.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Have you read the on-line help and/or the manual entry for the Exception Handler?
Essentially it's a "listener" that sits on your design canvas and can initiate an action, or series of actions, if an "exception" occurs. A child job aborting is an example of an exception. You might, for example, cause a Notification Activity to be invoked by the Exception Handler to notify you by email that the exception has occurred.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
MukundShastri
Premium Member
Premium Member
Posts: 103
Joined: Tue Oct 14, 2003 4:07 am

Post by MukundShastri »

I have also tried to use the Exception handler in the sequncer , but it's giving me compilation error "This job has no start points defined".

As suggested by Ray above, I have created a sequencer in which first activity is the exception handler which triggers the notification activity by sending mail. But I am not able to compile the same.

Any inputs on this ??

[/img]
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

As noted by the compiler error you received, this stage (and anything hooked to it) cannot stand alone.

The Exception Handler is not the 'first activity', more like a last one. Your sequence job needs to contain a 'normal' (for lack of a better word) series of Server Jobs and/or other Stages that it runs in addition to the Exception Handler series you mention. They will only run if something goes wrong with your normal series of jobs. And unless you are running 7.1 the definition of 'goes wrong' that it handles is fairly limited, so it pays to read the documentation on it.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply