Drop Table

Support Forum for database administrators and web based access to important newsgroups related to databases
Register on Database Support Forum Edit your profileCalendarFind other Database Support forum membersFrequently Asked QuestionsSearch this forum -> 
For Database admins: Free Database-related Magazines Now Free shipping to Texas


Post New Thread










Thread
Author

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\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


Report this thread to moderator Post Follow-up to this message
Old Post
Chris Auer
11-26-05 01:23 AM


Sponsored Links





Last Thread Next Thread
Post New Thread

Microsoft SQL Server forum archive

Show a Printable Version Email This Page to Someone! Receive updates to this thread
Microsoft SQL Server
Access database support
PostgreSQL Replication
SQL Server ODBC
FoxPro Support
PostgreSQL pgAdmin
SQL Server Clustering
MySQL ODBC
Web Applications with dBASE
SQL Server CE
MySQL++
Sybase Database Support
MS SQL Full Text Search
PostgreSQL Administration
SQL Anywhere support
DB2 UDB Database
Paradox Database Support
Filemaker Database
Berkley DB
SQL 2000/2000i database
ASE Database
Forum Jump:
All times are GMT. The time now is 03:57 PM.

 
Mobile devices forum | Database support forum archive




Copyrights DropTable.com Database Support Forum 2004 - 2006