By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,718 Members | 1,220 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,718 IT Pros & Developers. It's quick & easy.

Can't send operator email in SQL Sever 2005

P: n/a
I have:

Set up Database Mail
Set up and Operator (me)
Set up a job to send a message to that operator.

When I run the TSQL
EXECUTE msdb.dbo.sp_notify_operator @name=N'Chris Auer',@body=N'wewqe'

I get the error
Msg 14636, Level 16, State 1, Procedure sp_send_dbmail, Line 94
No global profile is configured. Specify a profile name in the
@profile_name parameter.

When I run the job it get the error
Executing the query "EXECUTE msdb.dbo.sp_notify_operator @name=N'Chris
Auer',@body=N'wewqe'
" failed with the following error: "No global profile is configured.
Specify a profile name in the @profile_name parameter.". Possible
failure reasons: Problems with the query, "ResultSet" property not set
correctly, parameters not set correctly, or connection not established
correctly.

I have also modded the registry
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\MSSQL.1\SQLServerAgent
DatabaseMailProfile = The profile I have set up in Database Mail
UseDatabaseMail = 1

Any ideas?

Thanks,
Chris Auer

Nov 26 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.