Hi All,
sql server 2005 sp2
I am able to receive email notifications when a maintenance plan is executed
but not when the sql server agent job is executed.
According to the error log, "an attempt was made to send an email when no
email session has been established"
Any reason why it works for one but not the other?
Thanks.
JNDid you enable mail for SQL Agent? You need to configure
mail for Agent - If you view the properties for agent, go to
the Alert System window and set mail up on the screen.
-Sue
On Mon, 4 Jun 2007 11:05:22 -0400, "JN"
<jnsimex@.hotmail.com> wrote:
>Hi All,
>sql server 2005 sp2
>I am able to receive email notifications when a maintenance plan is execute
d
>but not when the sql server agent job is executed.
>According to the error log, "an attempt was made to send an email when no
>email session has been established"
>Any reason why it works for one but not the other?
>Thanks.
>JN
>|||Yes, I have a check mark besides "Enable mail profile" and configured the
sql server agent mail properties under the Alert System to use the Database
Mail with the Mail profile that I want to use.
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:ebm9635bakqghvfrelio40l4je9gmghed9@.
4ax.com...
> Did you enable mail for SQL Agent? You need to configure
> mail for Agent - If you view the properties for agent, go to
> the Alert System window and set mail up on the screen.
> -Sue
> On Mon, 4 Jun 2007 11:05:22 -0400, "JN"
> <jnsimex@.hotmail.com> wrote:
>
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment