Sending Mail

[poornima.chandramouli]

I'm creating a reject file in a job,If there are any records present in the reject file,i should send a mail to a appropriate DL.

Current Approach:

I was populating a new coumn with default value as '1' & populating the aggregation of the particular default column in another file & then read the count file,then check for it's value if it's value is greater than 0 then i'll mailing the rejected file to the DL,if my reject file doesn't have any reords i should send a mail as 'NO Records Rejected' to another DL.

But I got a new problem here,like if nothing was rejected i.e., if my reject file doesn't have any record,my aggregation is not working,becoz there won't be any reords flowing into my aggregator,So it doesn't output any records.

How to achieve it.

[Sainath.Srinivasan]

To keep the same working mechanism, in your count agg job, add a row generator with a zero value in the column and funnel together.

[chulett]

Another thought, dump the file/aggregator approach and use DSGetLinkInfo() after the job completes to see how many rows were written to the reject file. Email based on that count.