Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databasesI 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
Post Follow-up to this message
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread