The below code working fine... I want send mail when difference data apperaing.. output like below, if Difference data = 0 don't want send mail.

Machine-CM6

Instance -23

InstanceA -19

Diff -4

EXEC msdb.dbo.sp_send_dbmail @profile_name='db_mail',

@recipients='ananad@xyz.com',

@subject='Alert Instance',

@query= 'Select A.MACHINE, A.Instance, B.InstanceA, (B.InstanceA-A.Instance) as Diff from (select MACHINE, COUNT(*) as Instance from PROD.dbo.CM_INSTANCE group by MACHINE) A,(Select COUNT(*)/4 as InstanceA from PROD.dbo.CM_INSTANCE) B where (B.InstanceA-A.Instance) < -3 or (B.InstanceA-A.Instance) > 3'