问在Server 2008中使用sp_send_dbmail发送的邮件很少

EN

CREATE procedure [dbo].[sp_dataRefreshNotification]  
AS  
BEGIN  
DECLARE @ToMail VARCHAR(20)  
DECLARE @Body1 VARCHAR(MAX) =   
'Dear User,  
Data has been refreshed.  
Regards,  
IT Support Team  

Note: This is an auto generated e-mail, please do not reply this mail. '      

SELECT DISTINCT RecipientAddress FROM dbo.RecipientAddressList  
OPEN notification_cursor  
FETCH NEXT FROM notification_cursor  
INTO @ToMail  

WHILE @@FETCH_STATUS = 0  
BEGIN
Waitfor Delay '000:00:10' 
EXEC msdb.dbo.sp_send_dbmail  
@profile_name  ='aaaa',    
@Recipients = @Tomail,  
@Subject = 'Required Data',      
@Body = @Body1  
FETCH NEXT FROM notification_cursor  
INTO @ToMail  
END  
CLOSE notification_cursor  
DEALLOCATE notification_cursor  
END  

CREATE PROCEDURE [dbo].[sp_dataRefreshNotification]  
AS  
BEGIN  
  SET NOCOUNT ON;
    DECLARE @ToMail VARCHAR(MAX);  
    DECLARE @Body1 VARCHAR(MAX);

SET @Body1  =   'Dear User, ' + CHAR(10) + 
                'Data has been refreshed.   ' + CHAR(10) + 
                'Regards,   ' + CHAR(10) + 
                'IT Support Team   ' + CHAR(10) + CHAR(10) + 

                'Note: This is an auto generated e-mail, please do not reply this mail.  ' + CHAR(10)    


    SELECT @ToMail = COALESCE(@ToMail+';' ,'') + RecipientAddress 
    FROM (SELECT DISTINCT RecipientAddress 
          FROM dbo.RecipientAddressList) t

    EXEC msdb.dbo.sp_send_dbmail  @profile_name  ='aaaa'
                                 ,@Recipients = @Tomail
                                 ,@Subject = 'Required Data'
                                 ,@Body = @Body1  

END