How to send email only the number of records processed

aladap12 · Post by **aladap12** » Wed Aug 12, 2009 3:01 pm

Hi flokes

I have an issue..

In my job sequencer I am unsing email notification activity.
In this activity I have attached job repot and sending it mangers.
Now they are asking me to send me only part of the report like total records processed and total records missed instead of job report.

How can I achive this in datastage.

Thanks
VKR

ray.wurlod · Post by **ray.wurlod** » Wed Aug 12, 2009 4:46 pm

I'd use a Routine activity.

RAJARP · Post by **RAJARP** » Thu Aug 13, 2009 3:10 am

hi ,
I had this requirement once.i used a routine activity with 'DSJ.LINKROWCOUNT ' to achieve that.

Regards,
raja R p

aladap12 · Post by **aladap12** » Fri Aug 14, 2009 6:39 am

Raja,

Thanks for the reply, could you please tell me little more detail,as i have to do this in my work. please help me out,

Thanks in Advance
vkr

RAJARP wrote:hi ,
I had this requirement once.i used a routine activity with 'DSJ.LINKROWCOUNT ' to achieve that.

Regards,
raja R p

chulett · Post by **chulett** » Fri Aug 14, 2009 7:19 am

In other words, you'll need to create a "report" with just specfically those two metrics. And one way to do that is by using the DSGetLinkInfo() function in a custom routine with the DSJ.LINKROWCOUNT InfoType to get the count of the records that went down the 'processed' link and the 'missed' link in a job... or you may need to compute what was 'missed' depending on what that means.

Read about that function in the online help and search for it here for examples of how people have used it.