how to get the count after all itteration is finished and get one mail with with all itteartion count in one mail.

[sbxr]

FYI @shong 

Hi Team,

i have a file through which i am iterating values of sql query, for example

"select TOP "+((Integer)globalMap.get("row1.Hits")+"from table name, and then insert into another table and send mail notification after all 5 iteration ie 5*10=50  insert.

i am using tmssqloutput_1_nb_line_inserted to get the count , which is fine but the thing is i am getting 5 notification for each iteration , how can i consolidate the count for all iteration and get only one notification  instead of 5 after all 5 iteration is complete , i am using the mail component after subjobok.

Thanks,

[Anonymous]

Can you please upload a screenshot of your current job design?

Regards
Shong

[akash4]

Instead of using "OnSubjobOk" for mail use tPostjob component it will run after the iteration completion. 

You will get only one notification instead of Five.

Please mark it as a solution if it is as per your expectation.