Skip to Content
avatar image
Former Member

BODS - mail with error notifications

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Apr 27, 2017 at 03:40 PM

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 28, 2017 at 08:13 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 10, 2017 at 11:48 AM

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

    Add comment
    10|10000 characters needed characters exceeded