Can't send operator email in SQL Sever 2005

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

.

Relevant Pages

  • Re: SQL 2005 Database Mail Setup
    ... MAPI profile. ... Since Database mail does not use the MAPI ... profile, that is not necessary. ... > You'll need to have at least SQLSErverAgent service running under the same ...
    (microsoft.public.sqlserver.setup)
  • Re: ConnectComputer Still not working
    ... Use moveuser.exe to migrate the profile. ... Login locally to the XP Pro client computer and create a new local user ... Logoff and logon to the XP Pro client computer using the local account ... specify only user for local ...
    (microsoft.public.windows.server.sbs)
  • Re: ConnectComputer Still not working
    ... > A. Use moveuser.exe to migrate the profile. ... Login locally to the XP Pro client computer and create a new local ... > account that is a member of the local ... Specify domain users in DOMAIN/user ...
    (microsoft.public.windows.server.sbs)
  • Re: Way to Specify Profile for Outlook ?
    ... NameSpace.Logon has some optional parameters to specify password, UI, & new ... > Dim OutMail As Outlook.MailItem ... > Is there a way within the VB code to specifiy the Outlook profile to use? ...
    (microsoft.public.dotnet.languages.vb)
  • Re: how copy local accounts user profile to another with vbscript
    ... >> To copy a user profile ... >> To specify who is permitted to use the copied profile ... > should be able to use the CopyFolder method of the Script Runtime: ...
    (microsoft.public.windows.server.scripting)