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

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Geoff Albin » How to receive alerts when you centralize...

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

Rate Topic

Display Mode

Topic Options

Author

Message

Geoff A

Posted Wednesday, May 23, 2012 9:27 PM

SSC-Addicted

Group: General Forum Members
Last Login: Monday, May 20, 2013 7:10 AM
Points: 485, Visits: 1,568

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

Post #1305490

lgarlick

Posted Friday, June 01, 2012 3:43 PM

Forum Newbie

Group: General Forum Members
Last Login: Friday, June 01, 2012 3:39 PM
Points: 1, Visits: 2

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.

Post #1310027

Geoff A

Posted Saturday, June 02, 2012 11:08 AM

SSC-Addicted

Group: General Forum Members
Last Login: Monday, May 20, 2013 7:10 AM
Points: 485, Visits: 1,568

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.

Post #1310107

« Prev Topic | Next Topic »

Permissions