Modifying the EmailNotification Stage

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
rkumar28
Participant
Posts: 43
Joined: Tue Mar 30, 2004 9:39 am

Modifying the EmailNotification Stage

Post by rkumar28 »

Hi,

I am using an email notification stage in a sequence to deliver an email once the load finishes. The sequence runs mulitple jobs.....
Is there a way to modify the default job status that is sent in the email. Actually I am trying to add: Total number of rows processed by the Sequence in the end of the email.
Is there a way to do that.....

Thanks
Raj
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

No, the stage itself is not modifiable and does not take parameters in the body of the email.

You'd need to look into writing your own routine to wrapper 'sendmail' or whatever you are using for email. That way you could build it to take parameters or to do whatever it is you needed. Then use the Routine Activity stage or perhaps run it 'after job'.

Your other option - if you have 7.5 - is to write the total information to a flat file and then include it as an attachment.
-craig

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