Skip to Content
0

BODS - mail with error notifications

Apr 27, 2017 at 03:16 PM

98

avatar image
Former Member

Hi everybody,

I use BODS ver 4.2 and SQL Server 2012. I created Job which contain Catch and try and one DataFlow. DataFlow takes data from csv files and transform into target table. I made some error in DF (change data type from date to int) and of course the process failed.

Is it possible to get mail notification about error (error text also + name DF)? This error comes from BODS -> Log and choose
see attached file bods-error.jpg

Kind Regards

bods-error.jpg (66.0 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Dirk Venken
Apr 27, 2017 at 03:40 PM
0

Yes. Use smtp_to or mail_to built-in function. Check the SAP Data Services Reference Guide for details.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Apr 28, 2017 at 08:13 AM
0

Hi Dirk,

thank you for your answer. Maybe I didn't write it clearly but I'd like to get in mail error message (as I attached in screen)
How can I pass error message into mail?

Regards

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member May 10, 2017 at 11:48 AM
0

Just use the the built-in functions error_message() and / or error_context(). For more details check the Reference Guide.

Share
10 |10000 characters needed characters left characters exceeded