Its very important to give the correct @Profile_Name which are configured for a Data base while we are executing the sp_send_dbmail.
Sometimes, everything seems to be correct, even though you wont receive mail and you could not figure out what could be the issue.
So, first get to know are you giving correct @Profile_Name or not, that you can see using the following predefined system functions
EXEC msdb.dbo.sysmail_help_principalprofile_sp;
When we executes the above query you will see different @Profile_Names which are configured.
Sometimes, everything seems to be correct, even though you wont receive mail and you could not figure out what could be the issue.
So, first get to know are you giving correct @Profile_Name or not, that you can see using the following predefined system functions
EXEC msdb.dbo.sysmail_help_principalprofile_sp;
When we executes the above query you will see different @Profile_Names which are configured.
No comments:
Post a Comment