StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POProblems with sending notification emails from SQL Server 2008
text
Body
copied!<p>I have a problem setting up email notifications in SQL Server 2008.</p> <p>I am using SQL Server 2008 to build a data cube. This process consists of several jobs, that are all scheduled to run each night at a specific time. To see whether a job was running without any failure, it is possible to set up email notification.</p> <p><a href="http://new.smilinginthesun.de/stackoverflow/01emailOperator.png" rel="noreferrer">http://new.smilinginthesun.de/stackoverflow/01emailOperator.png</a> <a href="http://new.smilinginthesun.de/stackoverflow/02emailNotification.png" rel="noreferrer">http://new.smilinginthesun.de/stackoverflow/02emailNotification.png</a></p> <p>Unfortunately, no email is sent even though I think I have set up database mail correctly. </p> <p>All guides I can found just explains, how to set up database mail (eg. <a href="http://blog.sqlauthority.com/2008/08/23/sql-server-2008-configure-database-mail-send-email-from-sql-database/" rel="noreferrer">http://blog.sqlauthority.com/2008/08/23/sql-server-2008-configure-database-mail-send-email-from-sql-database/</a>), but thats it.<br> If I sent a mail to test functionality (via test email button or from T-SQL script) it works just fine and the email arrives. But when using the notification feature in a job, it doesn't even create a <code>sysmail_mailitems</code> or <code>sysmail_log</code> entry.<br> I have also send an email using <code>sp_notify_operator</code>, successfully. So the operator set up seems to work, too. (Thanks, Joe Stefanelli, for the hint.)</p> <p>There is a great workaround written for SQL Server 2005, that works for me, too: <a href="http://www.howtogeek.com/howto/database/sending-automated-job-email-notifications-in-sql-server-with-smtp/" rel="noreferrer">http://www.howtogeek.com/howto/database/sending-automated-job-email-notifications-in-sql-server-with-smtp/</a>, but why isn't it possible to just use that build-in functionality?</p> <p>Does anyone knows if there is anything else to do, to make that email notification task work properly? Thanks in advise.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload