MS SQL Server - Trouble with email alerts in SQL 2005..

Author

Trouble with email alerts in SQL 2005..

davconts@gmail.com

2006-10-24, 6:31 pm

Hi all,

Ok I am trying to send out an email if a maintenence plan fails.

I think I've set everything up correctly, I can send a test email from
the Database Mail entry in the Object Explorer but I can't seem to get
an email from within a plan etc.

Steps i've done:

1) Enabled database mail in the surface configuration (not sure if I
needed to do this or not)
Haven't restarted SQL service (again, not sure if I need to do this
or not. I'm not actually sending any emails via SQL queries)

2) Added a new Database Mail profile with relevent SMTP details. Test
email works fine.

3) Added a new operator. Simply put a Name, and an email name. No
other options ticked/added. The operator is enabled.

Testing it in a plan/related to plans:

1) Ok I've tried adding a "Add operator" step in my maintenence plan
when a step completed but I get no email.

2) I also went to the SQL Server Agent / Jobs and went to the
properties of one of them and added a notification to email the
operator when the job succeeds. Again, no email.

----------

So I'm a bit stumped - have a missed something? Is there a way I can
check if something is not working right.. any ideas on how to test this
further?

I can supply any additional information that I might have missed above
if anyone requires it..

Thanks very much!

David

John Bell

2006-10-24, 6:31 pm

Hi

Are you using Localsystem as the SQL Server service account, if not are you
logged in as the service account when you create/test the profile?

John

"davconts@gmail.com" wrote:

> Hi all,
>
> Ok I am trying to send out an email if a maintenence plan fails.
>
> I think I've set everything up correctly, I can send a test email from
> the Database Mail entry in the Object Explorer but I can't seem to get
> an email from within a plan etc.
>
> Steps i've done:
>
> 1) Enabled database mail in the surface configuration (not sure if I
> needed to do this or not)
> Haven't restarted SQL service (again, not sure if I need to do this
> or not. I'm not actually sending any emails via SQL queries)
>
> 2) Added a new Database Mail profile with relevent SMTP details. Test
> email works fine.
>
> 3) Added a new operator. Simply put a Name, and an email name. No
> other options ticked/added. The operator is enabled.
>
> Testing it in a plan/related to plans:
>
> 1) Ok I've tried adding a "Add operator" step in my maintenence plan
> when a step completed but I get no email.
>
> 2) I also went to the SQL Server Agent / Jobs and went to the
> properties of one of them and added a notification to email the
> operator when the job succeeds. Again, no email.
>
> ----------
>
> So I'm a bit stumped - have a missed something? Is there a way I can
> check if something is not working right.. any ideas on how to test this
> further?
>
> I can supply any additional information that I might have missed above
> if anyone requires it..
>
> Thanks very much!
>
> David
>
>

davconts@gmail.com

2006-10-24, 6:31 pm

John Bell wrote:
> Hi
>
> Are you using Localsystem as the SQL Server service account, if not are you
> logged in as the service account when you create/test the profile?
>
> John

Thanks for the reply John.

SQL Server is using a domain account, not LocalSystem.

I also logged in/tested using the same domain account that the sql
service is logged in as.

Sponsored Links