In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.
ALTER PROCEDURE "amos"."send_email"(@mail_from varchar(80),@mailto varchar(80),@e_subject varchar(255),@msg long varchar) as /* @parameter_name parameter_type [= default_value] [OUTPUT], ... */ begin declare @rc integer execute @rc = xp_startmail mail_user = @mail_from --If successful logon to mail if @rc = 0 begin execute @rc = xp_sendmail recipient = @mailto,subject = @e_subject,"message" = @msg --If mail sent successfully, stop if @rc = 0 execute xp_stopmail end end
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.