Emails repeating and growing...

My dept has a SQL Server that uses an SMTP server to distribute emails for
Job Completion notifications. We recently had the server rebooted and I
received a small flood of emails. I've since asked for a daily reboot and
have been receiving a growing number of emails at the time of reboot (3am).
I'm recieving emails from 7/1/05 forward on a daily basis.
I opened up Outlook and there are no emails stuck in the Outbox. Would any
of you have an idea where to look?
FYI :
SQL Server SP4
SQL has it's own ID on this machine with it's own mail profile
This mail profile is shared by both Agent and SQL Server
POP3 goes through a Lotus Domino POP3 interface
I don't think the POP3 has any bearing on it... but since the whole
Send/Recieve process is touchy maybe there's something there.
Any suggestions would be appreciatedOk... maybe an easier question would be... where do I find the SQL Server
outbound mail queue?
"Peter Capazzi" wrote:
> My dept has a SQL Server that uses an SMTP server to distribute emails for
> Job Completion notifications. We recently had the server rebooted and I
> received a small flood of emails. I've since asked for a daily reboot and
> have been receiving a growing number of emails at the time of reboot (3am).
> I'm recieving emails from 7/1/05 forward on a daily basis.
> I opened up Outlook and there are no emails stuck in the Outbox. Would any
> of you have an idea where to look?
> FYI :
> SQL Server SP4
> SQL has it's own ID on this machine with it's own mail profile
> This mail profile is shared by both Agent and SQL Server
> POP3 goes through a Lotus Domino POP3 interface
> I don't think the POP3 has any bearing on it... but since the whole
> Send/Recieve process is touchy maybe there's something there.
> Any suggestions would be appreciated|||SQL Server doesn't have any mail queue. Xp_sendmail sends the email to MAPI synchronously. This is
why it is a bad idea to send email from a trigger, for example. Also, MAPI isn't the best choice for
a service. Have you considered using xp_smtp_sendmail? www.sqldev.net.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Peter Capazzi" <PeterCapazzi@.discussions.microsoft.com> wrote in message
news:E10AA6E4-D1F0-4C8A-B8E4-571FF79DF107@.microsoft.com...
> Ok... maybe an easier question would be... where do I find the SQL Server
> outbound mail queue?
> "Peter Capazzi" wrote:
>> My dept has a SQL Server that uses an SMTP server to distribute emails for
>> Job Completion notifications. We recently had the server rebooted and I
>> received a small flood of emails. I've since asked for a daily reboot and
>> have been receiving a growing number of emails at the time of reboot (3am).
>> I'm recieving emails from 7/1/05 forward on a daily basis.
>> I opened up Outlook and there are no emails stuck in the Outbox. Would any
>> of you have an idea where to look?
>> FYI :
>> SQL Server SP4
>> SQL has it's own ID on this machine with it's own mail profile
>> This mail profile is shared by both Agent and SQL Server
>> POP3 goes through a Lotus Domino POP3 interface
>> I don't think the POP3 has any bearing on it... but since the whole
>> Send/Recieve process is touchy maybe there's something there.
>> Any suggestions would be appreciated|||Well, these notifications are coming from the pager system in SQL Server...
in that repsect I don't think I have much of a choice.
So what can I do to analzye MAPI to see if these messages are simply sitting
in a queue somewhere? If I delete all mail profiles and recreate will it be
resolved?
"Tibor Karaszi" wrote:
> SQL Server doesn't have any mail queue. Xp_sendmail sends the email to MAPI synchronously. This is
> why it is a bad idea to send email from a trigger, for example. Also, MAPI isn't the best choice for
> a service. Have you considered using xp_smtp_sendmail? www.sqldev.net.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Peter Capazzi" <PeterCapazzi@.discussions.microsoft.com> wrote in message
> news:E10AA6E4-D1F0-4C8A-B8E4-571FF79DF107@.microsoft.com...
> > Ok... maybe an easier question would be... where do I find the SQL Server
> > outbound mail queue?
> >
> > "Peter Capazzi" wrote:
> >
> >> My dept has a SQL Server that uses an SMTP server to distribute emails for
> >> Job Completion notifications. We recently had the server rebooted and I
> >> received a small flood of emails. I've since asked for a daily reboot and
> >> have been receiving a growing number of emails at the time of reboot (3am).
> >> I'm recieving emails from 7/1/05 forward on a daily basis.
> >>
> >> I opened up Outlook and there are no emails stuck in the Outbox. Would any
> >> of you have an idea where to look?
> >>
> >> FYI :
> >> SQL Server SP4
> >> SQL has it's own ID on this machine with it's own mail profile
> >> This mail profile is shared by both Agent and SQL Server
> >> POP3 goes through a Lotus Domino POP3 interface
> >> I don't think the POP3 has any bearing on it... but since the whole
> >> Send/Recieve process is touchy maybe there's something there.
> >>
> >> Any suggestions would be appreciated
>|||You can get job notification and alerts from Agent through SMTP directly with a little work:
http://www.karaszi.com/SQLServer/info_no_mapi.asp
> So what can I do to analzye MAPI to see if these messages are simply sitting
> in a queue somewhere?
I suggest you ask in a mail/exchange group.
> If I delete all mail profiles and recreate will it be
> resolved?
I don't know if it will be resolved, but I tend to start troubleshooting by deleting and creating
the MAPI profile.
Btw, I believe that some configurations, you need to actually have Outlook running in order for the
emails to leave the queue. That is why I prefer to use Outlook 2000. However, I can imagine that
even with Outlook 2000, this can happen based on the backend storage. KB, Google and time is your
friend.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Peter Capazzi" <PeterCapazzi@.discussions.microsoft.com> wrote in message
news:21681631-A554-45A1-8234-0996FE8A6929@.microsoft.com...
> Well, these notifications are coming from the pager system in SQL Server...
> in that repsect I don't think I have much of a choice.
> So what can I do to analzye MAPI to see if these messages are simply sitting
> in a queue somewhere? If I delete all mail profiles and recreate will it be
> resolved?
> "Tibor Karaszi" wrote:
>> SQL Server doesn't have any mail queue. Xp_sendmail sends the email to MAPI synchronously. This
>> is
>> why it is a bad idea to send email from a trigger, for example. Also, MAPI isn't the best choice
>> for
>> a service. Have you considered using xp_smtp_sendmail? www.sqldev.net.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "Peter Capazzi" <PeterCapazzi@.discussions.microsoft.com> wrote in message
>> news:E10AA6E4-D1F0-4C8A-B8E4-571FF79DF107@.microsoft.com...
>> > Ok... maybe an easier question would be... where do I find the SQL Server
>> > outbound mail queue?
>> >
>> > "Peter Capazzi" wrote:
>> >
>> >> My dept has a SQL Server that uses an SMTP server to distribute emails for
>> >> Job Completion notifications. We recently had the server rebooted and I
>> >> received a small flood of emails. I've since asked for a daily reboot and
>> >> have been receiving a growing number of emails at the time of reboot (3am).
>> >> I'm recieving emails from 7/1/05 forward on a daily basis.
>> >>
>> >> I opened up Outlook and there are no emails stuck in the Outbox. Would any
>> >> of you have an idea where to look?
>> >>
>> >> FYI :
>> >> SQL Server SP4
>> >> SQL has it's own ID on this machine with it's own mail profile
>> >> This mail profile is shared by both Agent and SQL Server
>> >> POP3 goes through a Lotus Domino POP3 interface
>> >> I don't think the POP3 has any bearing on it... but since the whole
>> >> Send/Recieve process is touchy maybe there's something there.
>> >>
>> >> Any suggestions would be appreciated
>>