my xp_sendmail is granted execute rights to public, so there isn't any
permission problem. The stored procedure is run by the same group of users.
eg. he execute the procedure now, it failed. Then he execute it immediate
again and it'll pass. It happens almost everyday. it seems like everday the
first execute will fail, but subsequent execute will pass.