Home > MSSQL > Msg 14607, Level 16, State 1, Procedure sysmail_verify_profile_sp, Line 42 profile name is not valid Error came when execute test mail

Msg 14607, Level 16, State 1, Procedure sysmail_verify_profile_sp, Line 42 profile name is not valid Error came when execute test mail

Error:

We need to check the profile name by executing query,

SELECT [profile_id]
,[name]
,[description]
,[last_mod_datetime]
,[last_mod_user]
,’EXEC msdb.dbo.sp_send_dbmail
@profile_name = ‘ ‘ ‘ + name + ‘ ‘ ‘,
@recipients = ‘ ‘abc@abc.com’ ‘,
@subject = ‘ ‘ Test’ ‘,
@body  = ‘ ‘Message’ ‘,
@body_format = ‘ ‘HTML’ ‘;’ AS TestSQL
FROM [msdb].[dbo].[sysmail_profile]

Advertisements
Categories: MSSQL
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: