Post reply

How to receive alerts when you centralize your SQL Server Event Logs.

  • May 23, 2012 at 9:27 pm

    #392332

    Comments posted to this topic are about the item How to receive alerts when you centralize your SQL Server Event Logs.

  • June 1, 2012 at 3:43 pm

    #1496125

    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.

  • June 2, 2012 at 11:08 am

    #1496194

    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.

  • May 9, 2014 at 11:04 am

    #1712279

    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