Send RowCount as Email

[karthi_gana]

All,


My Job design :

Code: Select all

FeedFile   ------------         -----> New_Symbols_Identified
(Seq File)         |              |        (seq file)
                       |              |
                       v             |
                     Transformer
                     ^      |
                     |       | 
                     |       | 
Symbols-------------        ------------- Existing Symbols(seq file)

I would like to attach the below details in the email body to send it to the support/user team.

No of Rows Received = 5000 (example)
No of Rows Processed = 4990 (example)
No of Rows Rejected = 10 (example)

[chulett]

If you can get the information you want to send into a file then you can send it out in an email as an attachment but there's nothing "out of the box" to get any kind of variable text into the body of an email. To do that, you would have to write your own emailing routine, one that either called your email program of choice directly and built the body dynamically or leveraged the built in DSSendMail() function. You could even script something where you write out the file and then script a call to sendmail (or whatever) and incorporate the contents of the file into the body.

In other words, many ways to solve this but all require some 'special' coding on your part.

[anbu]

Check this link
http://dsxchange.com/viewtopic.php?t=13 ... t=linkinfo

[arunpramanik]

Play with the below function -

Code: Select all

DSGetLinkInfo(JobHandle,StageName,LinkName,DSJ.LINKROWCOUNT)

[chulett]

Don't know about anyone else, but I answered the way that I did because the question was how to "send rowcount as email" specifically sending them in the email body - not how to get the counts to send.

[JRodriguez]

The notification activity does not allow parameters for the body of the email, but you can used the DSSendMail utility routine for this purpose

This is a built-in routine that comes out of the box. Look under "Routine" in the project's repository windows