tSendMail - change Importance Flag at run-time

jay6 — Tue, 14 Feb 2017 14:32:40 GMT

Hello,

Does anyone know how to change the Importance flag on the tSendMail component at run-time. I've searched but cannot see any subjects or post on here or anywhere on Google.

Here's the scenario:

input file --> get counts --> remove duplicates --> add to SQL --> get SQL counts --> tJava (to do some calculations and construct the email body) --> send email
And yes I'm using context variables to store certain information.

I have a job that has one tSendMail component. The job adds data to an SQL Server table. I count the number of records that are in the original file and then I have a count of the number of record actually added to the SQL table. It's possible for the original data to contain duplicate records. This is eliminated in the job so the count from the original records could be different to what actually goes into SQL. One way or another an email alert needs to be sent that the job has completed including a summary of the counts. What I need to do is change the 'Importance' of the email alert to 'High' instead of normal when the figures do not match. The default setting is normal. How do I change the Importance from normal to High at run-time? I'd prefer not to add another tSendMail component.

I'm using TDM platform v6.2

Thanks
Jay

Re: tSendMail - change Importance Flag at run-time

Anonymous — Mon, 06 Mar 2017 08:11:07 GMT

Hi,

You cannot change the flag at run-time when building your job in studio. Have you tried to change parameter from commandline?

In this way, you can change the flag at runtime by modifying the launch script.

Best regards

[left][font=Verdana, sans-serif] Sabrina[/font][/left]

Re: tSendMail - change Importance Flag at run-time

jay6 — Tue, 14 Mar 2017 12:55:58 GMT

Thanks Sabrina.

I thought as much that you cannot change the flag, but it's good to check just in case.
How would you achieve this using CommandLine. I have no idea.

Jay

topic tSendMail - change Importance Flag at run-time in Talend Studio

tSendMail - change Importance Flag at run-time

Re: tSendMail - change Importance Flag at run-time

Re: tSendMail - change Importance Flag at run-time