| Chris Auer 2005-11-25, 8:23 pm |
| 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\S
OFTWARE\Microsoft\Mi
crosoft SQL
Server\MSSQL.1\SQLServerAgent
DatabaseMailProfile = The profile I have set up in Database Mail
UseDatabaseMail = 1
Any ideas?
Thanks,
Chris Auer
|