Issue 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

SQL Server Administration (2008)

Issue with Database Mail

Author

Topic

rajan.nithin
Starting Member

42 Posts

Posted - 2011-09-07 : 09:12:39

Hi,

I have scheduled multiple jobs using Database Mail on our production server. From 2nd of September we have not received any mails. I did check the Logs, the jobs are getting executed, but when I check the Database Mail logs, there are no logs after September 1st. I restarted the SQL Server Agent too. What could be the issue?

I am not receiving Test Mail too.

We are using SQL Server 2008 Standard Edition.

Regards,
Nithin

Ankit Mathur
Starting Member

24 Posts

Posted - 2011-09-09 : 02:16:04

Hi,

Have you enabled Mail Profile in SQL Server Agent Properties.
I'm sure you must've checked but still better to look once more.

Ankit

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2011-09-09 : 14:12:50

you should run a sql profiler to check what is going on behind the scenes

or you can follow this: http://msdn.microsoft.com/en-us/library/ms187540.aspx

--------------------
keeping it simple...

rajan.nithin
Starting Member

42 Posts

Posted - 2011-09-12 : 06:53:09

Mail profile already enabled, I restarted the Database Mail service, Deleted the existing profiles and accounts, then created a new profile & account. Yet the issue unresolved. In the Database Mail logs i can find only the entries for restarting the Mail service, No logs generated for the Test Mails sent.

quote:
Originally posted by Ankit Mathur

Hi,

Have you enabled Mail Profile in SQL Server Agent Properties.
I'm sure you must've checked but still better to look once more.

Ankit

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources