send email to me when job fails

[Dhruv]

1. I'm trying to get the notifications working on the scheduled jobs.
I want to email me when the job fails. I created an operator
(dmalhotr) and given me as the email address.

Here is the error what I'm getting when I'm pressing the test button
to email myself in properties dmalhotr operator (hope that makes
sense).

Error 22022: sqlserveragent error: the sqlserveragent mail session is
not running; check the mail profile and/or the sqlserveragent service
startup account in the sqlserveragent properties dialog.

I cancel out of it. Then I go to support services --> sql mail -->
right-click properties (WE HAVE LOTUS NOT EXCHANGE HERE- dont know
whether that makes a difference).

It says profile name Outlook and I click test. It says Successfully
started (and stopped) a MAPI session with this profile.

I go back to the operator and then click test to send email and I get
the same error. I started and stopped sql server agent and still get
the same error.

Not sure how this works, please send me an email as to what I'm doing
wrong

Thanks

:DHRUV

[John Bell]

Hi

SQL Agent Mail needs to be set up separately to SQL Mail. See the following
on how to set it up:
http://msdn.microsoft.com/library/de...rverE-mail.asp

John

"Dhruv" <dm**********@yahoo.com> wrote in message
news:b6*************************@posting.google.co m...

1. I'm trying to get the notifications working on the scheduled jobs.
I want to email me when the job fails. I created an operator
(dmalhotr) and given me as the email address.

Here is the error what I'm getting when I'm pressing the test button
to email myself in properties dmalhotr operator (hope that makes
sense).

Error 22022: sqlserveragent error: the sqlserveragent mail session is
not running; check the mail profile and/or the sqlserveragent service
startup account in the sqlserveragent properties dialog.

I cancel out of it. Then I go to support services --> sql mail -->
right-click properties (WE HAVE LOTUS NOT EXCHANGE HERE- dont know
whether that makes a difference).

It says profile name Outlook and I click test. It says Successfully
started (and stopped) a MAPI session with this profile.

I go back to the operator and then click test to send email and I get
the same error. I started and stopped sql server agent and still get
the same error.

Not sure how this works, please send me an email as to what I'm doing
wrong

Thanks

:DHRUV