EMAIL ON BODS job per status

[LeeFung]

I need to set up an email alert for a job that runs every 20 minutes . Depending on status of job (fail/success/ warning) , the email will be different. First it looks like I need to use Try/Catch to set up the logic; second, the email part needs a script? I need some guidance from you experts and friends..... thanks so much!!!

[jmuiruri]

Greetings lifengwu,

This a topic that has been asked in the community and answered. SAP Data Services provides the smtp_to() function that helps you send emails. Please see the syntax of the function in the link below

• smtp_to()
  

smtp_to(<recipients_list>, <subject>, <message>, <number_of_trace_lines>, <number_of_error_lines>)

Please see the following solutions.

• How to send email from SAP BODS
• Unable to send mail using data services?
• SAP Data Services – Mailing Functionality

References

• smtp_to
• 1629314 - How to set or change SMTP settings in Data Services 3.x

Best Regards

Joseph

[LeeFung]

I was more asking if a job fails, send email; if it succeeds send a different email ... how to set it up?

[jmuiruri]

Hi lifengwu,

Please see the above updated answer.

Best Regards,

Joseph