Each time I test the email in SQL Server 2005 it goes into a queue. The mai
l
works fine in SQL 2000. There are about 25 emails in the queue and no
amount of configuring or dropping the DBMail accounts seems to be able to ge
t
the queue to send.
example
EXEC msdb.dbo.sp_send_dbmail
@.profile_name = 'SUPERHOSS',
@.recipients = 'jlongstreet@.Applied-Textiles.com',
@.body = 'The stored procedure finished successfully.',
@.subject = 'Automated Success Message' ;
Reply from the server "Mail queued." Everything appears to be configured
correctly. Exchange server name is configured correctly... default email
client has an account on the network that is configured to send... there is
a
receive box that allows for a reply to address which is also configured.
The 2005 server is now live and it would be nice to have it send out job
failure notices. I'm not sure what it is that I am overlooking.
Regards,
Jamieprobably as silly question. DBMail uses SMTP. Is it running and will your
Exchange server accept it?
Chris
"thejamie" <thejamie@.discussions.microsoft.com> wrote in message
news:8EA12340-FA56-4432-8306-6235DF373E74@.microsoft.com...
> Each time I test the email in SQL Server 2005 it goes into a queue. The
> mail
> works fine in SQL 2000. There are about 25 emails in the queue and no
> amount of configuring or dropping the DBMail accounts seems to be able to
> get
> the queue to send.
> example
> EXEC msdb.dbo.sp_send_dbmail
> @.profile_name = 'SUPERHOSS',
> @.recipients = 'jlongstreet@.Applied-Textiles.com',
> @.body = 'The stored procedure finished successfully.',
> @.subject = 'Automated Success Message' ;
> Reply from the server "Mail queued." Everything appears to be configured
> correctly. Exchange server name is configured correctly... default email
> client has an account on the network that is configured to send... there
> is a
> receive box that allows for a reply to address which is also configured.
> The 2005 server is now live and it would be nice to have it send out job
> failure notices. I'm not sure what it is that I am overlooking.
> --
> Regards,
> Jamie|||That sounds like a plan. Thanks.
--
Regards,
Jamie
"Chris Wood" wrote:
> probably as silly question. DBMail uses SMTP. Is it running and will your
> Exchange server accept it?
> Chris
> "thejamie" <thejamie@.discussions.microsoft.com> wrote in message
> news:8EA12340-FA56-4432-8306-6235DF373E74@.microsoft.com...
>
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment