Data services. How to send an email from a data flow

[former_member212650]

Hi

I have a data flow and when the data flow completed I would like it to send an email. Currently we exec unix script to achieve this from the flow so we can do it .. but is there a native send email. I have seen an audit menu item but it is greyed out. any ideas.

Mike

[former_member198401]

Hi

You can always include your data flow in a Try Catch Block to catch any exceptions. If anything goes wrong within the data flow then you can write the smtp_to() to send an email under the script in Catch block

Another option is Audit for Data flow. When you click on any data flow, you can see the Audit Options under Tools or simply Right Click the Data Flow and Click Audit. You can set an Auditing Rule and if it fails then send it to distribution list. But the rule can be simple comparing a count between Source table and target table or you can also create your custom Rule.

Regards

Arun Sasi

[former_member212650]

Hi I have tested the smtp_to and yes it errors and refers to server manager

..my question is

we have UNIX not windows there is no GUI? how to we set it ?

any ideas?

[former_member198401]

Please refer to below SAP Note

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

Regards

Arun Sasi

[former_member212650]

Thats all great but where would one find - the SAP Data Services Server Manager?

Is it accessable from the PC client ? - this is what I can see from the PC

capture.png

any ideas or is it accessable some where else..

[Former Member]

Hi Mic,

You can find the Server Manager only in the server where SAP DS platform is installed.

Regards,

Bogdan

[former_member212650]

Thanks - we have a unix ds server ..but we'll give it a go thanks..!

[former_member212650]

Yes we still can't find this server manager ...on UNIX..any ideas..

[Former Member]

Nice one Arun.

I would like to add one point for Mike.

Before you use smtp_to() or use Audit functionality, you need to add smtp server details and sender mail id in your SAP Data Services Server Manager.

Please find the below screenshot.

Regards,

Soumyadeb Halder