up vote 1 down vote favorite
share [g+] share [fb]

I have set up 2 profiles. I can send a test email ok to one profile. I have set up 2 operators. I have a simple job (select coount(*)) which when it completes should send an email notification to the operator. Once the job is complete it should send an email to the operator. This does not seem to work, even though i can use the test database email and the email is sent using the correct profile. I have restarted the sql agent service too.

Anyone have suggestions??

Taruna

link|improve this question
See if these help: select * from msdb.dbo.sysmail_faileditems; select * from msdb.dbo.sysmail_log – jl01 Feb 22 at 15:18
feedback

2 Answers

up vote 1 down vote

When you send a test mail it will use your credentials. Jobs are run (by default) as the SQL Server Agent account.

Your Agent account probably does not have rights to send mail. Try logging in as your Agent account, and see if you can send. If not, your fix is to get mail working on your Agent account.

link|improve this answer
feedback
up vote 1 down vote

I believe the account sending the email needs "relay" permissions in Exchange, so you may need to work with your Exchange admin.

link|improve this answer
hi, Ok, I have that bit working following all the responses. I am now trying to email a group as opposed to just a single email address. When I change from myself to the group (group is set up in Outlook), no email is sent out?? But using my individual name (or anoone elses) its not??? any ideas. Thanks. – Trobbie Feb 23 at 10:42
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.