I have a stored procedure runs twice a day to send alerts email to people. portion of sp :
EXEC @status = master.dbo.xp_sendmail @recipients = @mailid,
@subject = @mailsub,
@message = @mailmessage,
@attachments = @mailattach,
@no_output = 'TRUE'
PRINT 'Mail Status:' + convert(varchar,@Status)
It runs fine in most of time, but starting 2 days ago, it executed fine, no error message, but there no email sent out.
Anyone know what is the problem?
Thank you.