Posted by Chris Auer on 11/26/05 03:35

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

• Next in forum: Re: 100 % CPU Usage
• Prev in forum: sql 2000 64-bit
• Thread view: Can't send operator email in SQL Sever 2005

[Reply to this message]