Database Mail not sending emails on job failure

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 2000 Forums

SQL Server Administration (2000)

Database Mail not sending emails on job failure

Author

Topic

sqlmannn
Starting Member

1 Post

Posted - 2006-03-08 : 09:58:59

I'm not sure I'm posting to the correct thread, but here it is anyway.

We have fired up Database Mail on our 2005 SQL Server and all seems to work on the test side. You can Right Click Database Mail and say Send Test Email and as long as you put in the entire email address i.e. me@yourserver.com the email comes back just fine.

The issue is that when I create a simple job that has one step which is to select from a table that doesn't exist, I cannot get a notification to be sent via email on the failure of the job.

Here is the message I get from the job history:

The last step to run was step 1 (exec syntax error). NOTE: Failed to notify 'MyID' via email.

Here is what is listed in the EventLog:

2006-03-07 12:08:48.543 The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2006-03-07T12:08:48). Exception Message: Cannot send mails to mail server. (The specified string is not in the form required for an e-mail addre

I'm not sure where to go.

Is it something to do with a service account?

We have Database Mail selected in the Alert System under SQL Server Agent. Although the TEST button is dimmed out when Database Mail is selected. I haven't changed it to SQLmail, but if you select SQLmail from that dropdown the TEST button comes to life.

. . .anyone have the answer?

Thanks,

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-03-09 : 13:37:25

http://support.microsoft.com/default.aspx?scid=kb;en-us;263556

Tara Kizer
aka tduggan

meastland
Starting Member

1 Post

Posted - 2006-08-04 : 16:24:54

SQL Mail in pre-2005 and Database Mail aren't the same thing, so the link in the previous post won't help you.

vhusain
Starting Member

7 Posts

Posted - 2009-02-10 : 05:14:04

Hi,

I faced the same problem and could solve it with the following

Went to Server Agent Properties, then Alert System, Enable Mail Profile "Database Mail".
Then to History and checked on Delete job history.
Stopped and Restarted SQL Server Agent and it worked.

I hope this helps.

Regards

VaishaliHusain

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources