• Just wrap the sql to send the email in a IF...BEGIN END

    e.g:

    if (Some SQL Statement that returns a count of errors) >= 1

    begin

    print 'send email'

    end

    else

    print 'dont send email'