How to receive alerts when you centralize your SQL Server Event Logs.
-
Comments posted to this topic are about the item How to receive alerts when you centralize your SQL Server Event Logs.
-
Geoff,
I have a DB Mail profile and account set up. I tested it and recieved an email. However, when I run the test script I get this error message. What am I missing?
"Msg 14636, Level 16, State 1, Procedure sp_send_dbmail, Line 107
No global profile is configured. Specify a profile name in the @profile_name parameter."
I was looking through the trigger for a place to define the profile name, but did not find anything.
-
You do not have a default mail profile set up.
select * from [msdb].[dbo].[sysmail_profile]
select * from [msdb].[dbo].[sysmail_principalprofile]
Run to see your profile names and if any are set to default.
A "is_default" value of 1 is required.
Thanks.
-
Thank you Geoff for this fine and informative articles.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply