DSXchange

Posted: **Mon Mar 28, 2011 7:20 am**

Hi ...

I have an requirement like to send a notification mail if the count of records in two tables not same, those two tables populated in same job.

Any suggestions how to handle this

Posted: **Mon Mar 28, 2011 10:16 am**

dr.murthy wrote:Hi ...

I have an requirement like to send a notification mail if the count of records in two tables not same, those two tables populated in same job.

Any suggestions how to handle this

Compare the two counts may be like

if count1=count2 then 'Y' else 'N' and use DSSETUSERSTATUS routine

and then send a notification only when userstatus='N'

Posted: **Mon Mar 28, 2011 11:21 am**

Why bother with the "Y" and "N"?

Code: Select all

If Count1 <> Count2 Then Call DSSetUserStatus(arg) Else NULL

DSXchange

Send a notification mail when count mismatches

Send a notification mail when count mismatches

Re: Send a notification mail when count mismatches