Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Community,
I'm new to talend and wanted to execute an job which would send my Sql query output as mail to the recipients .The query needs to be run on daily basis and the output should be attached to mail.It'd be great if anyone can help me with components and connection.
Thanks in advance!
Hello,
Please have a look at this related topic:https://community.talend.com/t5/Design-and-Development/resolved-Sending-query-result-by-mail/m-p/100...
Let us know if it helps.
Best regards
Sabrina
Hello,
Please have a look at this related topic:https://community.talend.com/t5/Design-and-Development/resolved-Sending-query-result-by-mail/m-p/100...
Let us know if it helps.
Best regards
Sabrina
Hi Sabrina,
Thanks for your reply-that was of great help.I would appreciate if you'll help me to get the output which is sent in mail in tabular form.Following is the example that would give you brief idea about my query.
The output I want in mail:
schema1 schema2 schema3
data data data
data data data
data data data
The output I'm getting:
schema1
data
data
data
schema2
data
data
data
schema3
data
data
data
Thanks in advance!
Best Regards.
Hello,
What's your output component? Could you please post your current job design screenshot here?
Best regards
Sabrina