"Vee" <vee.frost@gmail.com> wrote in message
news:1108923003.867755.315540@z14g2000cwz.googlegroups.com...
> 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
>

"Vee" <vee.frost@gmail.com> wrote in message
news:1109775537.831837.223960@g14g2000cwa.googlegroups.com...
> 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
>