I have recently discovered the notification stage and would like to include the $ErrSource, $ErrNumber, and $ErrMessage in the body of my email.
I find them availalble through the ellipses (...) on the email addresses and subject fields, but not the body.
Is there a way to include these in the body of the email?
Thanks
Bob
$ErrMessage in body of email from notification stage
Moderators: chulett, rschirm, roy
Not specifically. There is a check box to include errors in the outgoing email, but it is basically excerpts from job logs. There is no support for Job Parameters in the Notification Activity stage but I can't say for sure regarding environment variables.
Give it a try, let us know.
Give it a try, let us know.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You alternative is to create your own mailer routine and invoke it through a Routine activity rather than a Notification activity. This approach gives you complete flexibility as to what you include in your email.
Within the routine you call DSSendMail to send the mail. There is an example of how to use this function within the routines supplied with DataStage.
Within the routine you call DSSendMail to send the mail. There is an example of how to use this function within the routines supplied with DataStage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.