E-mail notification issues

I just set up an SMTP email account though the Management Studio à Server à Database Mail.The test email was successfully delivered to my mail box.

Now I’m trying to test the notifications.I created an Operator with my email address, and my test job is set to email the operator when the job completes using the email account above.

However I am not receiving any emails upon the completion of the job.When I go to notification history under the Operator, there is none.

What am I missing?

Thanks a lot for your help!

The answer is simple - reboot SQL Server Agent|||

I am connecting remotely to my server. Is there a way to test an email account or do I need to log in locally? I have set up an operator and am able to set a notification on my job, but it doesn't send the email. I'm not able to see the same path you used above. Any ideas?

|||

LoveDanger wrote:

I just set up an SMTP email account though the Management Studio à Server à Database Mail. The test email was successfully delivered to my mail box.

I think I have a similar scenario here (see also SQL Server Agent Mail (SQL Server 2005 Database E-Mail) in this forum).

LoveDanger wrote:

Now I’m trying to test the notifications. I created an Operator with my email address, and my test job is set to email the operator when the job completes using the email account above.

It looks like I forgot to create an operator. What exactly is this and where can I create this? I'm using the german version of SQL Server and can't translate the term operator to a SQL Server related term i know.

Thanx in advance and best regards,
Gerald

|||I have found it now in the German version, defined an operator and now everything is working fine :-)

@.LoveDanger
Try to do the trouble shooting for database mail, i.e. have a look in the associated tables, e.g.

SELECT * FROM msdb.dbo.sysmail_allitems
SELECT * FROM msdb.dbo.sysmail_sentitems
SELECT * FROM msdb.dbo.sysmail_faileditems
SELECT * FROM msdb.dbo.sysmail_event_log

regards,
Gerald

|||

I couldn't find that because I'm connecting to an earlier version of SQL Server with a newer version.