<p>When I use the sp_send_dbmail stored procedure, I get a message saying that my mail was queued. However, it never seems to get delivered. I can see them in the queue if I run this SQL:</p>

<pre><code>SELECT * FROM msdb..sysmail_allitems WHERE sent_status = 'unsent'
</code></pre>

<p>This SQL returns a 1:</p>

<pre><code>SELECT is_broker_enabled FROM sys.databases WHERE name = 'msdb'
</code></pre>

<p>This stored procedure returns STARTED:</p>

<pre><code>msdb.dbo.sysmail_help_status_sp
</code></pre>

<p>The appropriate accounts and profiles have been set up and the mail was functioning at one point. There are no errors in msdb.dbo.sysmail_event_log. </p>

[{'answer_id': 9212, 'author': 'Stu', 'author_id': 414, 'author_profile': 'https://Stackoverflow.com/users/414', 'pm_score': 2, 'selected': False, 'text': '<p>Have you tried </p>\n\n<pre><code>sysmail_stop_sp\n</code></pre>\n\n<p>then </p>\n\n<pre><code>sysmail_start_sp\n</code></pre>\n'}, {'answer_id': 9875, 'author': 'Stu', 'author_id': 414, 'author_profile': 'https://Stackoverflow.com/users/414', 'pm_score': 2, 'selected': True, 'text': "<p>Could be oodles of things. For example, I've seen (yes, actually seen) this happen after:</p>\n\n<ul>\n<li>Domain controller reboot </li>\n<li>Exchange server reboot</li>\n<li>Router outage</li>\n<li>Service account changes</li>\n<li>SQL Server running out of disk space</li>\n</ul>\n\n<p>So until it happens again, I wouldn't freak out over it.</p>\n"}, {'answer_id': 5979759, 'author': 'UB.', 'author_id': 142962, 'author_profile': 'https://Stackoverflow.com/users/142962', 'pm_score': 2, 'selected': False, 'text': '<p>I had the same problem and this is how I was able to resolve it.</p>\n\n<p>Go to <strong>Sql Agent >> Properties >> Alert System >> Check the Enable box for DBMail</strong> and add a profile.</p>\n\n<p><strong>Restart</strong> Agent and it works since then.</p>\n\n<p>Hope this helps,\n_Ub</p>\n'}]
['https://Stackoverflow.com/questions/9002', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/162/']