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

  • Geoff A

    SSChampion

    Points: 11417

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

  • lgarlick

    SSC Rookie

    Points: 45

    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.

  • Geoff A

    SSChampion

    Points: 11417

    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.

  • Eirikur Eiriksson

    SSC Guru

    Points: 182430

    Thank you Geoff for this fine and informative articles.

    😎

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply