sqlserver数据库使用存储过程和dbmail实现定时发送邮件

Create PROCEDURE [dbo].[sp_send_error_alert]
AS
declare
@v_contentnvarchar(max),
@v_mail_tonvarchar(500),
@v_bodynvarchar(max),
@v_titilenvarchar(100)
,@v_br_idnvarchar(50)
,@v_installmentsnvarchar(10)
,@v_remarknvarchar(100)
BEGIN
SETNOCOUNTON;
set@v_titile='测试邮件内容标题;
set@v_content=\'';

DECLAREcursor_repaymentCURSORFOR
SELECT
br_id
,installments
,remark
fromdw_account_repaymentt
where
status!=1
andis_del=0
orderbyt.add_datetimedesc;

OPENcursor_repayment
FETCHNEXTFROMcursor_repaymentINTO
@v_br_id--标ID
,@v_installments--期数
,@v_remark--错误描述
WHILE@@FETCH_STATUS=0
BEGIN

set@v_content=@v_content+\'tr>td>'+@v_br_id+\'/td>'+\'td>'+@v_installments+\'/td>'+\'td>'+@v_remark+\'/td>/tr>';

fetchnextfromcursor_repaymentinto
@v_br_id--标ID
,@v_installments--期数
,@v_remark--错误描述
end;

CLOSEcursor_repayment;--关闭游标
DEALLOCATEcursor_repayment;--清空游标

ifLEN(@v_content)>0
begin
SET@v_body=\'html>H1>自动还款所有异常列表/H1>bodybgcolor=white>tableborder=1>tr>th>标ID/th>th>期数/th>th>错误描述/th>/tr>'
SET@v_body=@v_body+@v_content+\'/table>/body>/html>'
EXECmsdb.dbo.sp_send_dbmail
@recipients=N\'接收用户地址1@qq.com;接收用户地址2@qq.com',@body=@v_body,@body_format=\'HTML'
,@subject=@v_titile,@profile_name=\'上一节点的配置文件名（db_profiler）