sql server - In msdb.dbo.sp_send_dbmail, @profile_name is not valid -
i use sql server job execute sendemail stored procedure. job working fine when @recipients our specified email address. since couldn't log our specified email address check whether email has been received, want change @recipients email address the question when make changed, job history shows job not executed. error profile_name not valid does have idea this? here example. exec msdb.dbo.sp_send_email @profile_name = 'isss group', @recipients = 'isss@xxx.edu', @body = @mess,--@mess table @body_format = 'html', @subject = 'student information update', @from_address = 'administration@xxx.edu'; i want change @recipients = 'isss@xxx.edu' @recipients = 'myemail@xxx.edu' to check whether email has been received. once change it, sql server job failed. error shows profile name not valid. you must pass name of registered profile; can't make them on-the-fly. however, assume want different d