DSXchange

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

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.

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.