Hello,

I have set up a job that executes numerous DTS packages on a nightly
basis to transfer a large amount of data from a legacy database to SQL
Server 2000. The job is expected to notify our department if the Job
has failed or succeeded via email. Every now and again I get the
following message

"The job succeeded. The Job was invoked by Schedule 114 (Daily
Transfer Schedule). The last step to run was step 25 (Shrink AIC
Reporting Database). NOTE: Failed to notify 'Group IT' via email."

Would anyone know why the email portion of this Job would fail?

Thanks in advance,

V

Sounds like you are using SQL Agent Mail. Have you tested this with any job?
I wouldn't rely on the mail notifications from SQL Agent as MAPI is just not
up to it in my experience. Add your own notifications using an SMTP based
mechanism, and even then still monitor your jobs externally to that SQL
instance.


--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

"Vee" <vee.frost (AT) gmail (DOT) com> wrote

Hi Darren,

Thanks for the reply, yes I have been using SQL Agent Mail, and I use
it to notify me on failers for all jobs that I run on the SQL Server,
and every now and again it seems to fail on random jobs. Which is very
annoying when it fails AND doesnt notify me! I think you are right
about MAPI, I went to a Microsoft Security Summit the other day, and
they are introducing SQL smtp mail with SQL 2005 because of the
limitations of SQL MAPI mail.

Thanks again,

V

SQL 2005 mail looks at lot better, and has some nice features. In the
meantime I recommend you try on of these or even both for different areas of
your systems-

SMTP Mail Task
(http://www.sqldev.net/dts/SMTPTask.htm)


XPSMTP
(http://www.sqldev.net/xp/xpsmtp.htm)


--
Darren Green
http://www.sqldts.com
http://www.sqlis.com
"Vee" <vee.frost (AT) gmail (DOT) com> wrote

Thanks Darren,

I will try these SMTP options. If you don't hear from me, it has solved
my problem!

V