problems with database mail - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

problems with database mail

Author

Topic

sebastian11c
Posting Yak Master

129 Posts

Posted - 2012-01-05 : 11:16:09

hi there i followed this blog and tried to configure the database mail
seems pratty simple, but doesnt work on my db
http://blog.sqlauthority.com/2008/08/23/sql-server-2008-configure-database-mail-send-email-from-sql-database/
but it doesnt work

no mails are sent

i checked SELECT * FROM msdb.dbo.sysmail_allitems

and the status is "unsent" loginmode is 'sa'

i dont know whats the problem,, please help me

sebastian11c
Posting Yak Master

129 Posts

Posted - 2012-01-05 : 11:24:34

also when im going to send a new mail i always have to run
exec sysmail_start_sp
and later run the code , example
exec sysmail_start_sp
EXEC msdb.dbo.sp_send_dbmail
@recipients=N'sebastian11c@gmail.com',@body='Message Body',
@sensitivity ='Personal',
@importance ='High',
@copy_recipients ='steve.wilson@mycompany.com',@subject ='Message Subject',@profile_name ='pruebas ajustev'

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources