I have created a database profile and finished setting up the database mail.Right now my subject is AMC SQL ALERTS and I am trying to change this to AMC SQL ALERTS_WHD_BACKUP...I have changed this in display name..But I am still getting the same AMC SQL
ALERTS when email has been sent..Please help..
Do you want to change the subject line? How did you change the subject name?
You can try to send a test mail and manual change the subject line for the email in the subject box. Or you can test email from SQL Server to execute the statement below likes:
declare @body1 varchar(100)
set @body1 = 'Server :'+@@servername+ ' My First Database Email '
EXEC msdb.dbo.sp_send_dbmail @recipients=’’,
@subject = 'My Mail Test',----change the subject line here
@body = @body1,
@body_format = 'HTML' ;