Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to receive alerts when you centralize your SQL Server Event Logs. Expand / Collapse
Author
Message
Posted Wednesday, May 23, 2012 9:27 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, June 24, 2014 12:24 PM
Points: 514, Visits: 1,717
Comments posted to this topic are about the item How to receive alerts when you centralize your SQL Server Event Logs.
Post #1305490
Posted Friday, June 1, 2012 3:43 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, June 1, 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
Posted Saturday, June 2, 2012 11:08 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, June 24, 2014 12:24 PM
Points: 514, Visits: 1,717
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
Posted Friday, May 9, 2014 11:04 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 9:37 AM
Points: 1,133, Visits: 3,274
Thank you Geoff for this fine and informative articles.
Post #1569389
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse