Send a notification mail when count mismatches

[dr.murthy]

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

[rsunny]

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'

[ray.wurlod]

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

Code: Select all

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