Hi.
I am trying to set a trigger to send an email notification. is this possible
in SQL 2000?
What i am trying to do is send an email saying that a client has been here
for 12 months and would like to raise the rent.
Regards WilburSomething similar to this laid out in http://www.aspfaq.com/2403
"panda" <panda@.discussions.microsoft.com> wrote in message
news:30401819-8EE7-42E3-8898-2F8E75880C40@.microsoft.com...
> Hi.
> I am trying to set a trigger to send an email notification. is this
> possible
> in SQL 2000?
> What i am trying to do is send an email saying that a client has been here
> for 12 months and would like to raise the rent.
> Regards Wilbur|||thank you very much.
"Aaron Bertrand [SQL Server MVP]" wrote:
> Something similar to this laid out in http://www.aspfaq.com/2403
>
>
> "panda" <panda@.discussions.microsoft.com> wrote in message
> news:30401819-8EE7-42E3-8898-2F8E75880C40@.microsoft.com...
>
>
Showing posts with label notification. Show all posts
Showing posts with label notification. Show all posts
Thursday, March 22, 2012
Wednesday, March 21, 2012
e-mail setup on SQL 2000 std
Hello All,
I am trying to set up e-mail notification, but when I open SQL Server Agent
(Properties) the Mail Profile is outgreyed, and I cannot choose any Mail
Profile.
I have Outlook 2002 (XP) installed on the machine, and I tried configuring a
profile with POP and IMAP account, but no mather what I do, the Mail Profile
is stil outgreyed. I don't have MAPI access from that machine, but according
to some books I refered to it shouldn't be a must.
As I can see, either it should be a MAPI, or I am missing something that
should be installed on SQL server, a component or something like that.
Any ideas?
Thanx in advance,
Zoran
YOu have t configure the EMail inBox for the service Account SQL Server
Agent is running on. If this is confugured you will be able to see the
Profile. Anyway, if you want to use another program not relying on MAPI, try
the SMTP_Sendmail which is free of charge :-)
http://www.sqldev.net/xp/xpsmtp.htm
HTH, Jens Smeyer.
"Kizetoni" <kizetoni@.mail.ru> schrieb im Newsbeitrag
news:ODJc24CQFHA.3788@.tk2msftngp13.phx.gbl...
> Hello All,
> I am trying to set up e-mail notification, but when I open SQL Server
> Agent
> (Properties) the Mail Profile is outgreyed, and I cannot choose any Mail
> Profile.
> I have Outlook 2002 (XP) installed on the machine, and I tried configuring
> a
> profile with POP and IMAP account, but no mather what I do, the Mail
> Profile
> is stil outgreyed. I don't have MAPI access from that machine, but
> according
> to some books I refered to it shouldn't be a must.
> As I can see, either it should be a MAPI, or I am missing something that
> should be installed on SQL server, a component or something like that.
> Any ideas?
> Thanx in advance,
> Zoran
>
|||http://www.aspfaq.com/2403
This is my signature. It is a general reminder.
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"Kizetoni" <kizetoni@.mail.ru> wrote in message
news:ODJc24CQFHA.3788@.tk2msftngp13.phx.gbl...
> Hello All,
> I am trying to set up e-mail notification, but when I open SQL Server
> Agent
> (Properties) the Mail Profile is outgreyed, and I cannot choose any Mail
> Profile.
> I have Outlook 2002 (XP) installed on the machine, and I tried configuring
> a
> profile with POP and IMAP account, but no mather what I do, the Mail
> Profile
> is stil outgreyed. I don't have MAPI access from that machine, but
> according
> to some books I refered to it shouldn't be a must.
> As I can see, either it should be a MAPI, or I am missing something that
> should be installed on SQL server, a component or something like that.
> Any ideas?
> Thanx in advance,
> Zoran
>
I am trying to set up e-mail notification, but when I open SQL Server Agent
(Properties) the Mail Profile is outgreyed, and I cannot choose any Mail
Profile.
I have Outlook 2002 (XP) installed on the machine, and I tried configuring a
profile with POP and IMAP account, but no mather what I do, the Mail Profile
is stil outgreyed. I don't have MAPI access from that machine, but according
to some books I refered to it shouldn't be a must.
As I can see, either it should be a MAPI, or I am missing something that
should be installed on SQL server, a component or something like that.
Any ideas?
Thanx in advance,
Zoran
YOu have t configure the EMail inBox for the service Account SQL Server
Agent is running on. If this is confugured you will be able to see the
Profile. Anyway, if you want to use another program not relying on MAPI, try
the SMTP_Sendmail which is free of charge :-)
http://www.sqldev.net/xp/xpsmtp.htm
HTH, Jens Smeyer.
"Kizetoni" <kizetoni@.mail.ru> schrieb im Newsbeitrag
news:ODJc24CQFHA.3788@.tk2msftngp13.phx.gbl...
> Hello All,
> I am trying to set up e-mail notification, but when I open SQL Server
> Agent
> (Properties) the Mail Profile is outgreyed, and I cannot choose any Mail
> Profile.
> I have Outlook 2002 (XP) installed on the machine, and I tried configuring
> a
> profile with POP and IMAP account, but no mather what I do, the Mail
> Profile
> is stil outgreyed. I don't have MAPI access from that machine, but
> according
> to some books I refered to it shouldn't be a must.
> As I can see, either it should be a MAPI, or I am missing something that
> should be installed on SQL server, a component or something like that.
> Any ideas?
> Thanx in advance,
> Zoran
>
|||http://www.aspfaq.com/2403
This is my signature. It is a general reminder.
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"Kizetoni" <kizetoni@.mail.ru> wrote in message
news:ODJc24CQFHA.3788@.tk2msftngp13.phx.gbl...
> Hello All,
> I am trying to set up e-mail notification, but when I open SQL Server
> Agent
> (Properties) the Mail Profile is outgreyed, and I cannot choose any Mail
> Profile.
> I have Outlook 2002 (XP) installed on the machine, and I tried configuring
> a
> profile with POP and IMAP account, but no mather what I do, the Mail
> Profile
> is stil outgreyed. I don't have MAPI access from that machine, but
> according
> to some books I refered to it shouldn't be a must.
> As I can see, either it should be a MAPI, or I am missing something that
> should be installed on SQL server, a component or something like that.
> Any ideas?
> Thanx in advance,
> Zoran
>
e-mail setup on SQL 2000 std
Hello All,
I am trying to set up e-mail notification, but when I open SQL Server Agent
(Properties) the Mail Profile is outgreyed, and I cannot choose any Mail
Profile.
I have Outlook 2002 (XP) installed on the machine, and I tried configuring a
profile with POP and IMAP account, but no mather what I do, the Mail Profile
is stil outgreyed. I don't have MAPI access from that machine, but according
to some books I refered to it shouldn't be a must.
As I can see, either it should be a MAPI, or I am missing something that
should be installed on SQL server, a component or something like that.
Any ideas?
Thanx in advance,
ZoranYOu have t configure the EMail inBox for the service Account SQL Server
Agent is running on. If this is confugured you will be able to see the
Profile. Anyway, if you want to use another program not relying on MAPI, try
the SMTP_Sendmail which is free of charge :-)
http://www.sqldev.net/xp/xpsmtp.htm
HTH, Jens Süßmeyer.
"Kizetoni" <kizetoni@.mail.ru> schrieb im Newsbeitrag
news:ODJc24CQFHA.3788@.tk2msftngp13.phx.gbl...
> Hello All,
> I am trying to set up e-mail notification, but when I open SQL Server
> Agent
> (Properties) the Mail Profile is outgreyed, and I cannot choose any Mail
> Profile.
> I have Outlook 2002 (XP) installed on the machine, and I tried configuring
> a
> profile with POP and IMAP account, but no mather what I do, the Mail
> Profile
> is stil outgreyed. I don't have MAPI access from that machine, but
> according
> to some books I refered to it shouldn't be a must.
> As I can see, either it should be a MAPI, or I am missing something that
> should be installed on SQL server, a component or something like that.
> Any ideas?
> Thanx in advance,
> Zoran
>|||http://www.aspfaq.com/2403
--
This is my signature. It is a general reminder.
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"Kizetoni" <kizetoni@.mail.ru> wrote in message
news:ODJc24CQFHA.3788@.tk2msftngp13.phx.gbl...
> Hello All,
> I am trying to set up e-mail notification, but when I open SQL Server
> Agent
> (Properties) the Mail Profile is outgreyed, and I cannot choose any Mail
> Profile.
> I have Outlook 2002 (XP) installed on the machine, and I tried configuring
> a
> profile with POP and IMAP account, but no mather what I do, the Mail
> Profile
> is stil outgreyed. I don't have MAPI access from that machine, but
> according
> to some books I refered to it shouldn't be a must.
> As I can see, either it should be a MAPI, or I am missing something that
> should be installed on SQL server, a component or something like that.
> Any ideas?
> Thanx in advance,
> Zoran
>|||Yes! :o)
Aaron, thanx!
I checked the link you sent me, and I understood that I should be logging on
with SQL service account.
Once I did that, I could configure the whole thing!
Thanx again!
Regards, Zoran
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> skrev i en meddelelse
news:%23MjmN8CQFHA.2680@.TK2MSFTNGP09.phx.gbl...
> http://www.aspfaq.com/2403
> --
> This is my signature. It is a general reminder.
> Please post DDL, sample data and desired results.
> See http://www.aspfaq.com/5006 for info.
>
>
> "Kizetoni" <kizetoni@.mail.ru> wrote in message
> news:ODJc24CQFHA.3788@.tk2msftngp13.phx.gbl...
> > Hello All,
> >
> > I am trying to set up e-mail notification, but when I open SQL Server
> > Agent
> > (Properties) the Mail Profile is outgreyed, and I cannot choose any Mail
> > Profile.
> >
> > I have Outlook 2002 (XP) installed on the machine, and I tried
configuring
> > a
> > profile with POP and IMAP account, but no mather what I do, the Mail
> > Profile
> > is stil outgreyed. I don't have MAPI access from that machine, but
> > according
> > to some books I refered to it shouldn't be a must.
> >
> > As I can see, either it should be a MAPI, or I am missing something that
> > should be installed on SQL server, a component or something like that.
> >
> > Any ideas?
> >
> > Thanx in advance,
> > Zoran
> >
> >
>sql
I am trying to set up e-mail notification, but when I open SQL Server Agent
(Properties) the Mail Profile is outgreyed, and I cannot choose any Mail
Profile.
I have Outlook 2002 (XP) installed on the machine, and I tried configuring a
profile with POP and IMAP account, but no mather what I do, the Mail Profile
is stil outgreyed. I don't have MAPI access from that machine, but according
to some books I refered to it shouldn't be a must.
As I can see, either it should be a MAPI, or I am missing something that
should be installed on SQL server, a component or something like that.
Any ideas?
Thanx in advance,
ZoranYOu have t configure the EMail inBox for the service Account SQL Server
Agent is running on. If this is confugured you will be able to see the
Profile. Anyway, if you want to use another program not relying on MAPI, try
the SMTP_Sendmail which is free of charge :-)
http://www.sqldev.net/xp/xpsmtp.htm
HTH, Jens Süßmeyer.
"Kizetoni" <kizetoni@.mail.ru> schrieb im Newsbeitrag
news:ODJc24CQFHA.3788@.tk2msftngp13.phx.gbl...
> Hello All,
> I am trying to set up e-mail notification, but when I open SQL Server
> Agent
> (Properties) the Mail Profile is outgreyed, and I cannot choose any Mail
> Profile.
> I have Outlook 2002 (XP) installed on the machine, and I tried configuring
> a
> profile with POP and IMAP account, but no mather what I do, the Mail
> Profile
> is stil outgreyed. I don't have MAPI access from that machine, but
> according
> to some books I refered to it shouldn't be a must.
> As I can see, either it should be a MAPI, or I am missing something that
> should be installed on SQL server, a component or something like that.
> Any ideas?
> Thanx in advance,
> Zoran
>|||http://www.aspfaq.com/2403
--
This is my signature. It is a general reminder.
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"Kizetoni" <kizetoni@.mail.ru> wrote in message
news:ODJc24CQFHA.3788@.tk2msftngp13.phx.gbl...
> Hello All,
> I am trying to set up e-mail notification, but when I open SQL Server
> Agent
> (Properties) the Mail Profile is outgreyed, and I cannot choose any Mail
> Profile.
> I have Outlook 2002 (XP) installed on the machine, and I tried configuring
> a
> profile with POP and IMAP account, but no mather what I do, the Mail
> Profile
> is stil outgreyed. I don't have MAPI access from that machine, but
> according
> to some books I refered to it shouldn't be a must.
> As I can see, either it should be a MAPI, or I am missing something that
> should be installed on SQL server, a component or something like that.
> Any ideas?
> Thanx in advance,
> Zoran
>|||Yes! :o)
Aaron, thanx!
I checked the link you sent me, and I understood that I should be logging on
with SQL service account.
Once I did that, I could configure the whole thing!
Thanx again!
Regards, Zoran
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> skrev i en meddelelse
news:%23MjmN8CQFHA.2680@.TK2MSFTNGP09.phx.gbl...
> http://www.aspfaq.com/2403
> --
> This is my signature. It is a general reminder.
> Please post DDL, sample data and desired results.
> See http://www.aspfaq.com/5006 for info.
>
>
> "Kizetoni" <kizetoni@.mail.ru> wrote in message
> news:ODJc24CQFHA.3788@.tk2msftngp13.phx.gbl...
> > Hello All,
> >
> > I am trying to set up e-mail notification, but when I open SQL Server
> > Agent
> > (Properties) the Mail Profile is outgreyed, and I cannot choose any Mail
> > Profile.
> >
> > I have Outlook 2002 (XP) installed on the machine, and I tried
configuring
> > a
> > profile with POP and IMAP account, but no mather what I do, the Mail
> > Profile
> > is stil outgreyed. I don't have MAPI access from that machine, but
> > according
> > to some books I refered to it shouldn't be a must.
> >
> > As I can see, either it should be a MAPI, or I am missing something that
> > should be installed on SQL server, a component or something like that.
> >
> > Any ideas?
> >
> > Thanx in advance,
> > Zoran
> >
> >
>sql
e-mail setup on SQL 2000 std
Hello All,
I am trying to set up e-mail notification, but when I open SQL Server Agent
(Properties) the Mail Profile is outgreyed, and I cannot choose any Mail
Profile.
I have Outlook 2002 (XP) installed on the machine, and I tried configuring a
profile with POP and IMAP account, but no mather what I do, the Mail Profile
is stil outgreyed. I don't have MAPI access from that machine, but according
to some books I refered to it shouldn't be a must.
As I can see, either it should be a MAPI, or I am missing something that
should be installed on SQL server, a component or something like that.
Any ideas?
Thanx in advance,
ZoranYOu have t configure the EMail inBox for the service Account SQL Server
Agent is running on. If this is confugured you will be able to see the
Profile. Anyway, if you want to use another program not relying on MAPI, try
the SMTP_Sendmail which is free of charge :-)
http://www.sqldev.net/xp/xpsmtp.htm
HTH, Jens Smeyer.
"Kizetoni" <kizetoni@.mail.ru> schrieb im Newsbeitrag
news:ODJc24CQFHA.3788@.tk2msftngp13.phx.gbl...
> Hello All,
> I am trying to set up e-mail notification, but when I open SQL Server
> Agent
> (Properties) the Mail Profile is outgreyed, and I cannot choose any Mail
> Profile.
> I have Outlook 2002 (XP) installed on the machine, and I tried configuring
> a
> profile with POP and IMAP account, but no mather what I do, the Mail
> Profile
> is stil outgreyed. I don't have MAPI access from that machine, but
> according
> to some books I refered to it shouldn't be a must.
> As I can see, either it should be a MAPI, or I am missing something that
> should be installed on SQL server, a component or something like that.
> Any ideas?
> Thanx in advance,
> Zoran
>|||http://www.aspfaq.com/2403
This is my signature. It is a general reminder.
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"Kizetoni" <kizetoni@.mail.ru> wrote in message
news:ODJc24CQFHA.3788@.tk2msftngp13.phx.gbl...
> Hello All,
> I am trying to set up e-mail notification, but when I open SQL Server
> Agent
> (Properties) the Mail Profile is outgreyed, and I cannot choose any Mail
> Profile.
> I have Outlook 2002 (XP) installed on the machine, and I tried configuring
> a
> profile with POP and IMAP account, but no mather what I do, the Mail
> Profile
> is stil outgreyed. I don't have MAPI access from that machine, but
> according
> to some books I refered to it shouldn't be a must.
> As I can see, either it should be a MAPI, or I am missing something that
> should be installed on SQL server, a component or something like that.
> Any ideas?
> Thanx in advance,
> Zoran
>
I am trying to set up e-mail notification, but when I open SQL Server Agent
(Properties) the Mail Profile is outgreyed, and I cannot choose any Mail
Profile.
I have Outlook 2002 (XP) installed on the machine, and I tried configuring a
profile with POP and IMAP account, but no mather what I do, the Mail Profile
is stil outgreyed. I don't have MAPI access from that machine, but according
to some books I refered to it shouldn't be a must.
As I can see, either it should be a MAPI, or I am missing something that
should be installed on SQL server, a component or something like that.
Any ideas?
Thanx in advance,
ZoranYOu have t configure the EMail inBox for the service Account SQL Server
Agent is running on. If this is confugured you will be able to see the
Profile. Anyway, if you want to use another program not relying on MAPI, try
the SMTP_Sendmail which is free of charge :-)
http://www.sqldev.net/xp/xpsmtp.htm
HTH, Jens Smeyer.
"Kizetoni" <kizetoni@.mail.ru> schrieb im Newsbeitrag
news:ODJc24CQFHA.3788@.tk2msftngp13.phx.gbl...
> Hello All,
> I am trying to set up e-mail notification, but when I open SQL Server
> Agent
> (Properties) the Mail Profile is outgreyed, and I cannot choose any Mail
> Profile.
> I have Outlook 2002 (XP) installed on the machine, and I tried configuring
> a
> profile with POP and IMAP account, but no mather what I do, the Mail
> Profile
> is stil outgreyed. I don't have MAPI access from that machine, but
> according
> to some books I refered to it shouldn't be a must.
> As I can see, either it should be a MAPI, or I am missing something that
> should be installed on SQL server, a component or something like that.
> Any ideas?
> Thanx in advance,
> Zoran
>|||http://www.aspfaq.com/2403
This is my signature. It is a general reminder.
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"Kizetoni" <kizetoni@.mail.ru> wrote in message
news:ODJc24CQFHA.3788@.tk2msftngp13.phx.gbl...
> Hello All,
> I am trying to set up e-mail notification, but when I open SQL Server
> Agent
> (Properties) the Mail Profile is outgreyed, and I cannot choose any Mail
> Profile.
> I have Outlook 2002 (XP) installed on the machine, and I tried configuring
> a
> profile with POP and IMAP account, but no mather what I do, the Mail
> Profile
> is stil outgreyed. I don't have MAPI access from that machine, but
> according
> to some books I refered to it shouldn't be a must.
> As I can see, either it should be a MAPI, or I am missing something that
> should be installed on SQL server, a component or something like that.
> Any ideas?
> Thanx in advance,
> Zoran
>
Email or Pop-up Notification for Unscheduled SQL Server Shutdown
How do I go about creating a notification for unscheduled Server Shutdowns?Hi
Implement a monitoring tool like BigBrother, Tivoli or one of the tools from
Quest Software.
You could also write on and have it run as a service on the server,
listening for WMI events.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"tim" <tim@.discussions.microsoft.com> wrote in message
news:DFEAF0E6-CD4E-4E9C-8817-583CEC6BF70D@.microsoft.com...
> How do I go about creating a notification for unscheduled Server
> Shutdowns?|||There is always the possibility to check your application event log or write
a trigger on some events
But what if your server got suddenly unplugged?
Med Bouchenafa
"tim" <tim@.discussions.microsoft.com> wrote in message
news:DFEAF0E6-CD4E-4E9C-8817-583CEC6BF70D@.microsoft.com...
> How do I go about creating a notification for unscheduled Server
> Shutdowns?
Implement a monitoring tool like BigBrother, Tivoli or one of the tools from
Quest Software.
You could also write on and have it run as a service on the server,
listening for WMI events.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"tim" <tim@.discussions.microsoft.com> wrote in message
news:DFEAF0E6-CD4E-4E9C-8817-583CEC6BF70D@.microsoft.com...
> How do I go about creating a notification for unscheduled Server
> Shutdowns?|||There is always the possibility to check your application event log or write
a trigger on some events
But what if your server got suddenly unplugged?
Med Bouchenafa
"tim" <tim@.discussions.microsoft.com> wrote in message
news:DFEAF0E6-CD4E-4E9C-8817-583CEC6BF70D@.microsoft.com...
> How do I go about creating a notification for unscheduled Server
> Shutdowns?
Email or Pop-up Notification for Unscheduled SQL Server Shutdown
How do I go about creating a notification for unscheduled Server Shutdowns?
Hi
Implement a monitoring tool like BigBrother, Tivoli or one of the tools from
Quest Software.
You could also write on and have it run as a service on the server,
listening for WMI events.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"tim" <tim@.discussions.microsoft.com> wrote in message
news:DFEAF0E6-CD4E-4E9C-8817-583CEC6BF70D@.microsoft.com...
> How do I go about creating a notification for unscheduled Server
> Shutdowns?
|||There is always the possibility to check your application event log or write
a trigger on some events
But what if your server got suddenly unplugged?
Med Bouchenafa
"tim" <tim@.discussions.microsoft.com> wrote in message
news:DFEAF0E6-CD4E-4E9C-8817-583CEC6BF70D@.microsoft.com...
> How do I go about creating a notification for unscheduled Server
> Shutdowns?
Hi
Implement a monitoring tool like BigBrother, Tivoli or one of the tools from
Quest Software.
You could also write on and have it run as a service on the server,
listening for WMI events.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"tim" <tim@.discussions.microsoft.com> wrote in message
news:DFEAF0E6-CD4E-4E9C-8817-583CEC6BF70D@.microsoft.com...
> How do I go about creating a notification for unscheduled Server
> Shutdowns?
|||There is always the possibility to check your application event log or write
a trigger on some events
But what if your server got suddenly unplugged?
Med Bouchenafa
"tim" <tim@.discussions.microsoft.com> wrote in message
news:DFEAF0E6-CD4E-4E9C-8817-583CEC6BF70D@.microsoft.com...
> How do I go about creating a notification for unscheduled Server
> Shutdowns?
Email or Pop-up Notification for Unscheduled SQL Server Shutdown
How do I go about creating a notification for unscheduled Server Shutdowns?Hi
Implement a monitoring tool like BigBrother, Tivoli or one of the tools from
Quest Software.
You could also write on and have it run as a service on the server,
listening for WMI events.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"tim" <tim@.discussions.microsoft.com> wrote in message
news:DFEAF0E6-CD4E-4E9C-8817-583CEC6BF70D@.microsoft.com...
> How do I go about creating a notification for unscheduled Server
> Shutdowns?|||There is always the possibility to check your application event log or write
a trigger on some events
But what if your server got suddenly unplugged?
--
Med Bouchenafa
"tim" <tim@.discussions.microsoft.com> wrote in message
news:DFEAF0E6-CD4E-4E9C-8817-583CEC6BF70D@.microsoft.com...
> How do I go about creating a notification for unscheduled Server
> Shutdowns?
Implement a monitoring tool like BigBrother, Tivoli or one of the tools from
Quest Software.
You could also write on and have it run as a service on the server,
listening for WMI events.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"tim" <tim@.discussions.microsoft.com> wrote in message
news:DFEAF0E6-CD4E-4E9C-8817-583CEC6BF70D@.microsoft.com...
> How do I go about creating a notification for unscheduled Server
> Shutdowns?|||There is always the possibility to check your application event log or write
a trigger on some events
But what if your server got suddenly unplugged?
--
Med Bouchenafa
"tim" <tim@.discussions.microsoft.com> wrote in message
news:DFEAF0E6-CD4E-4E9C-8817-583CEC6BF70D@.microsoft.com...
> How do I go about creating a notification for unscheduled Server
> Shutdowns?
Monday, March 19, 2012
EMail Notifications
Yukon Apr '05 CTP
Using Notification Services
Trying to send out notifications by mail
Entry in the instanceconfig file
<DeliveryChannel>
<DeliveryChannelName>MailChannel</DeliveryChannelName>
<ProtocolName>SMTP</ProtocolName>
<Arguments>
<Argument>
<Name>SmtpServer</Name>
<Value>1.1.1.1</Value>
</Argument>
<Argument>
<Name>BodyEncoding</Name>
<Value>utf-16</Value>
</Argument>
</Arguments>
</DeliveryChannel>
AppDefinition File entry
<Distributors>
<Distributor>
<SystemName>%_NSSystem_%</SystemName>
<QuantumDuration>PT15S</QuantumDuration>
</Distributor>
</Distributors>
Same Notification to a text file works, while trying the mail notifications it throws up this error in the Windows Event log.
Description: Notifications reference non-existent subscribers or unknown subscriber device names. Run the NSDiagnosticFailedNotifications stored procedure and check for notifications with undefined delivery channel names. Add new subscribers or subscriber devices so that future notifications are delivered.
EventParameters:
Instance Name: TestNotificationsInstance
Application Name: Events
InstanceName: TestNotificationsInstance
ApplicationName: Events
Component: Generator
Thread: 10
Is there any other dependency to run Notification services ? SMTP service?
Have configured the access to smtp server to send out mails.
Rgds
mat -
"Notifications reference non-existent subscribers or unknown subscriber device names." makes me wonder about the subscriber devices. When you created the devices and the subscriptions, how did you reference them? I suspect the problem may be in the name of the device, possibly the name of the channel, when you created the subscription or device.
HTH...
--
Joe Webb
SQL Server MVP
~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/tg/detail/-/0972688811
I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)
As Joe points out, it could be that there are no subscriber devices for your new channel (Joe, we added this new error message to provide feedback about the classic "missing subscriber device problem"). But, your email seemed to imply that you created subscribers and configured them for the mail channel, so I'll assume that's fine.
I didn't see you mention anything about adding the required SMTP protocol configuration to your notification class. Something like this:
<NotificationClass>
...
<Protocols>
<Protocol>
<ProtocolName>SMTP</ProtocolName>
<Fields>
... Subject, To, From etc. field definitions.
</Fields>
That samples included with the June CTP show examples of how to configure the SMTP protocol in your notification class. If you need a code snippet, let me know and I'll dig one up, but there should be several in the samples.
Thanks
-shyam
Learn more about SQL-NS:
http://www.amazon.com/exec/obidos/tg/detail/-/0672326647/
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.|||Sorry for the delay in replying guys.
Got this working. Problems were
- Wrong device name in code while adding subscriptions, not the same as a defined device for the subscriber.
So a validation check for that would help.
- Then had to add the other fields for the SMTP protocol in the AppDefinition file.
From, Subject,To, BodyFormat etc...
Can't we have a GUI that does all these configs for notification? Helps to know what is mandatory/required.
Notification samples with Yukon Apr CTP did not have SMTP samples. ( or was it there somewhere)
Thanks for the help Shyam and Joe.|||
Hi Mat -
I've developed a little C# application that i use to create test notifications for my NS apps. It doesn't do everything you've asked for, but maybe you'll find it of some use. It's available for free on the resources sections of my web site (http://www.webbtechsolutions.com/downloads.aspx).
BTW - It's written using v1.1 of the .net framework, but could serve as a basis for a v2.0 project.
Cheers!
Joe
--
Joe Webb
SQL Server MVP
~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/tg/detail/-/0972688811
I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)
Email Notification with Custom Attachments using Notification Services 2005
Hi All,
I am using Notification Services 2005.I have done with the configuration and deployment of Notification Services 2005.Now i wanted to know how to send notifications via email with custom attachments.
Please help me out in this issue.
Amby
Hi Amby -[copied for a reply to your newsgroup posting]
The built-in SMTP delivery protocol doesn't support attachments. But
you do have a couple of options:
1) you can build a custom delivery protocol that uses SMTP to send
notifications with attachments. I don't have Shyam Pather's SQLNS book
in front of me at the moment, but I think he goes through a similar
example in it. It's for v2.0, not 2005, but the same concepts should
apply.
2) I've also sent notifications via SMTP that have a link to a
resource that they need rather than including it as an attachment. For
example, rather than attaching a PDF, I place the PDF on a web site
and then send a link to the PDF in the notification. This has worked
well for me.
HTH....
--
Joe Webb
SQL Server MVP
http://www.sqlns.com
~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/tg/detail/-/0972688811
I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)
E-mail notification when a record is added
I would like to be notified By E-Mail when a record is added to a particular
table in My SQL 2000 Database . How can I do That ?
Create a table to hold relevant information for the email to be sent.
Create a trigger on the table for which you want to be notified that does an INSERT to above table.
Create an SQL Server Agent job that reads off that table and uses xp_smtp_sendmail (www.sqldev.net)
to send the email.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"FRED" <FRED@.discussions.microsoft.com> wrote in message
news:76DD9CAD-74AC-43E4-A74C-6153F86EF3E3@.microsoft.com...
>I would like to be notified By E-Mail when a record is added to a particular
> table in My SQL 2000 Database . How can I do That ?
>
|||Hi,
1. Write a Insert trigger on that particular table.
2. COnfigure the SQL mail with a valid exchange server email account
3. Inside the trigger do
XP_SENDMAIL command (SEE BOOKS ONLINE for usage)
Thanks
Hari
SQL Server MVP
"FRED" <FRED@.discussions.microsoft.com> wrote in message
news:76DD9CAD-74AC-43E4-A74C-6153F86EF3E3@.microsoft.com...
>I would like to be notified By E-Mail when a record is added to a
>particular
> table in My SQL 2000 Database . How can I do That ?
>
table in My SQL 2000 Database . How can I do That ?
Create a table to hold relevant information for the email to be sent.
Create a trigger on the table for which you want to be notified that does an INSERT to above table.
Create an SQL Server Agent job that reads off that table and uses xp_smtp_sendmail (www.sqldev.net)
to send the email.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"FRED" <FRED@.discussions.microsoft.com> wrote in message
news:76DD9CAD-74AC-43E4-A74C-6153F86EF3E3@.microsoft.com...
>I would like to be notified By E-Mail when a record is added to a particular
> table in My SQL 2000 Database . How can I do That ?
>
|||Hi,
1. Write a Insert trigger on that particular table.
2. COnfigure the SQL mail with a valid exchange server email account
3. Inside the trigger do
XP_SENDMAIL command (SEE BOOKS ONLINE for usage)
Thanks
Hari
SQL Server MVP
"FRED" <FRED@.discussions.microsoft.com> wrote in message
news:76DD9CAD-74AC-43E4-A74C-6153F86EF3E3@.microsoft.com...
>I would like to be notified By E-Mail when a record is added to a
>particular
> table in My SQL 2000 Database . How can I do That ?
>
Email Notification Problem
Hi All,
I have a couple of w2k adv. svrs which are also running sql 2000. My DBA has
configured sp_send_mail using outlook 2000 which is also installed on these
servers.
This sp_send_mail is configured to send notifications on daily basis. Out of
25 notifications each day, 2 or 3 fails.
They claim the sp_send_mail stored procedure executes properly so the
problem is with the exchange svr even though there is no trace of these
failed messages in exchange nor even on the client computers where outlooks
mapi32 is initiated.
Is there any way I can figure out in outlook, on the client computers if
these failed messages are even initiated by outlook or not, even though they
claim their stored procedure executes properly always?
Nobody in the company has mail delivery problem with the exchange box or
their outlook clients. I have tested sending emails from outlook on these
servers without any failures yet they claim its exchange 2000.
Any ideas on how to resolve this permanently'The mail support that ships with SQL Server is not fun to work with as it uses MAPI and MAPI was
never designed to be used from services. Have you considered using xp_smtp_sendmail from
www.sqldev.net?
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"caddo65590" <caddo65590@.hotmail.com> wrote in message news:O0QAtnEtDHA.980@.TK2MSFTNGP10.phx.gbl...
> Hi All,
> I have a couple of w2k adv. svrs which are also running sql 2000. My DBA has
> configured sp_send_mail using outlook 2000 which is also installed on these
> servers.
> This sp_send_mail is configured to send notifications on daily basis. Out of
> 25 notifications each day, 2 or 3 fails.
> They claim the sp_send_mail stored procedure executes properly so the
> problem is with the exchange svr even though there is no trace of these
> failed messages in exchange nor even on the client computers where outlooks
> mapi32 is initiated.
> Is there any way I can figure out in outlook, on the client computers if
> these failed messages are even initiated by outlook or not, even though they
> claim their stored procedure executes properly always?
> Nobody in the company has mail delivery problem with the exchange box or
> their outlook clients. I have tested sending emails from outlook on these
> servers without any failures yet they claim its exchange 2000.
> Any ideas on how to resolve this permanently'
>
I have a couple of w2k adv. svrs which are also running sql 2000. My DBA has
configured sp_send_mail using outlook 2000 which is also installed on these
servers.
This sp_send_mail is configured to send notifications on daily basis. Out of
25 notifications each day, 2 or 3 fails.
They claim the sp_send_mail stored procedure executes properly so the
problem is with the exchange svr even though there is no trace of these
failed messages in exchange nor even on the client computers where outlooks
mapi32 is initiated.
Is there any way I can figure out in outlook, on the client computers if
these failed messages are even initiated by outlook or not, even though they
claim their stored procedure executes properly always?
Nobody in the company has mail delivery problem with the exchange box or
their outlook clients. I have tested sending emails from outlook on these
servers without any failures yet they claim its exchange 2000.
Any ideas on how to resolve this permanently'The mail support that ships with SQL Server is not fun to work with as it uses MAPI and MAPI was
never designed to be used from services. Have you considered using xp_smtp_sendmail from
www.sqldev.net?
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"caddo65590" <caddo65590@.hotmail.com> wrote in message news:O0QAtnEtDHA.980@.TK2MSFTNGP10.phx.gbl...
> Hi All,
> I have a couple of w2k adv. svrs which are also running sql 2000. My DBA has
> configured sp_send_mail using outlook 2000 which is also installed on these
> servers.
> This sp_send_mail is configured to send notifications on daily basis. Out of
> 25 notifications each day, 2 or 3 fails.
> They claim the sp_send_mail stored procedure executes properly so the
> problem is with the exchange svr even though there is no trace of these
> failed messages in exchange nor even on the client computers where outlooks
> mapi32 is initiated.
> Is there any way I can figure out in outlook, on the client computers if
> these failed messages are even initiated by outlook or not, even though they
> claim their stored procedure executes properly always?
> Nobody in the company has mail delivery problem with the exchange box or
> their outlook clients. I have tested sending emails from outlook on these
> servers without any failures yet they claim its exchange 2000.
> Any ideas on how to resolve this permanently'
>
email notification on job status
In MSDE, since there is no sql mail, I am thinking of doing the following:
1. write a shell script which will query the sysjobhistory table to
determine if any job failed. If so, then an email about the failure is sent
out.
Question: What should my sql command and my mail command look like. I dont
have much experience in shell scripting or am not very familiar with MSDB
database either.
hi,
inquisite wrote:
> In MSDE, since there is no sql mail, I am thinking of doing the
> following:
> 1. write a shell script which will query the sysjobhistory table to
> determine if any job failed. If so, then an email about the failure
> is sent out.
> Question: What should my sql command and my mail command look like. I
> dont have much experience in shell scripting or am not very familiar
> with MSDB database either.
if an SMPT solution is viable, I'd resort on xp_smpt extended stored
procedure provided at http://sqldev.net/xp/xpsmtp.htm
you can then code your task's step to send a mail on success or failure..
SQL Server MVP Tibor Karaszi presents and describes such a feature at
http://www.karaszi.com/sqlserver/info_no_mapi.asp
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||SMTP solution is not available. That is why I wanted to send an email through
some script running on the server.
"Andrea Montanari" wrote:
> hi,
> inquisite wrote:
> if an SMPT solution is viable, I'd resort on xp_smpt extended stored
> procedure provided at http://sqldev.net/xp/xpsmtp.htm
> you can then code your task's step to send a mail on success or failure..
> SQL Server MVP Tibor Karaszi presents and describes such a feature at
> http://www.karaszi.com/sqlserver/info_no_mapi.asp
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>
|||If an SMTP server is not available then how were you planing to send email?
Jim
"inquisite" <inquisite@.discussions.microsoft.com> wrote in message
news:D7FE12AC-C359-4B74-A8C6-E497686705CB@.microsoft.com...[vbcol=seagreen]
> SMTP solution is not available. That is why I wanted to send an email
> through
> some script running on the server.
> "Andrea Montanari" wrote:
1. write a shell script which will query the sysjobhistory table to
determine if any job failed. If so, then an email about the failure is sent
out.
Question: What should my sql command and my mail command look like. I dont
have much experience in shell scripting or am not very familiar with MSDB
database either.
hi,
inquisite wrote:
> In MSDE, since there is no sql mail, I am thinking of doing the
> following:
> 1. write a shell script which will query the sysjobhistory table to
> determine if any job failed. If so, then an email about the failure
> is sent out.
> Question: What should my sql command and my mail command look like. I
> dont have much experience in shell scripting or am not very familiar
> with MSDB database either.
if an SMPT solution is viable, I'd resort on xp_smpt extended stored
procedure provided at http://sqldev.net/xp/xpsmtp.htm
you can then code your task's step to send a mail on success or failure..
SQL Server MVP Tibor Karaszi presents and describes such a feature at
http://www.karaszi.com/sqlserver/info_no_mapi.asp
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||SMTP solution is not available. That is why I wanted to send an email through
some script running on the server.
"Andrea Montanari" wrote:
> hi,
> inquisite wrote:
> if an SMPT solution is viable, I'd resort on xp_smpt extended stored
> procedure provided at http://sqldev.net/xp/xpsmtp.htm
> you can then code your task's step to send a mail on success or failure..
> SQL Server MVP Tibor Karaszi presents and describes such a feature at
> http://www.karaszi.com/sqlserver/info_no_mapi.asp
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>
|||If an SMTP server is not available then how were you planing to send email?
Jim
"inquisite" <inquisite@.discussions.microsoft.com> wrote in message
news:D7FE12AC-C359-4B74-A8C6-E497686705CB@.microsoft.com...[vbcol=seagreen]
> SMTP solution is not available. That is why I wanted to send an email
> through
> some script running on the server.
> "Andrea Montanari" wrote:
E-mail notification issues
I just set up an SMTP email account though the Management Studio à Server à Database Mail.The test email was successfully delivered to my mail box.
Now I’m trying to test the notifications.I created an Operator with my email address, and my test job is set to email the operator when the job completes using the email account above.
However I am not receiving any emails upon the completion of the job.When I go to notification history under the Operator, there is none.
What am I missing?
Thanks a lot for your help!
The answer is simple - reboot SQL Server Agent|||I am connecting remotely to my server. Is there a way to test an email account or do I need to log in locally? I have set up an operator and am able to set a notification on my job, but it doesn't send the email. I'm not able to see the same path you used above. Any ideas?
|||
LoveDanger wrote:
I just set up an SMTP email account though the Management Studio à Server à Database Mail. The test email was successfully delivered to my mail box.
I think I have a similar scenario here (see also SQL Server Agent Mail (SQL Server 2005 Database E-Mail) in this forum).
Now I’m trying to test the notifications. I created an Operator with my email address, and my test job is set to email the operator when the job completes using the email account above.
It looks like I forgot to create an operator. What exactly is this and where can I create this? I'm using the german version of SQL Server and can't translate the term operator to a SQL Server related term i know.
Thanx in advance and best regards,
Gerald
|||I have found it now in the German version, defined an operator and now everything is working fine :-)
@.LoveDanger
Try to do the trouble shooting for database mail, i.e. have a look in the associated tables, e.g.
SELECT * FROM msdb.dbo.sysmail_allitems
SELECT * FROM msdb.dbo.sysmail_sentitems
SELECT * FROM msdb.dbo.sysmail_faileditems
SELECT * FROM msdb.dbo.sysmail_event_log
regards,
Gerald
|||
I couldn't find that because I'm connecting to an earlier version of SQL Server with a newer version.
E-mail notification issues
I just set up an SMTP email account though the Management Studio à Server à Database Mail.The test email was successfully delivered to my mail box.
Now I’m trying to test the notifications.I created an Operator with my email address, and my test job is set to email the operator when the job completes using the email account above.
However I am not receiving any emails upon the completion of the job.When I go to notification history under the Operator, there is none.
What am I missing?
Thanks a lot for your help!
The answer is simple - reboot SQL Server AgentEmail notification does not send
Hello,
re: SQL Server 2005, SP1
I set up Database Mail on a clustered server using the db mail wizard
in Management Studio. I set up an operator using a mail group. The test
email worked fine. I also restarted the SQL Server Agent on node 1 of
the cluster (twice).
Next, I set up a notification on a simple backup job to send an email
to the operator when the job completes.
However, the email is never sent out when the job completes. I have
checked the operator history and there is no history of an email ever
being sent. I also checked the current log and there are no error
messages whatsover regarding the mail not being sent. I also checked
the application log on node 1, and there is no error there either.
I have run the backup job several times now, sent myself another test
email from the server (which works fine), but for some reason the email
just won't send on job completion.
Has anyone had this problem and how to resolve it? I though restarting
the Agent would solve the problem, but it has not.
Thanks
I would check 2 things:
In Surface Configuration, is Database mail enabled
When you used the wizard to setup database mail, you had to create a
profle. Is that profile set as the "default"?
tootsuite@.gmail.com wrote:
> Hello,
> re: SQL Server 2005, SP1
> I set up Database Mail on a clustered server using the db mail wizard
> in Management Studio. I set up an operator using a mail group. The test
> email worked fine. I also restarted the SQL Server Agent on node 1 of
> the cluster (twice).
> Next, I set up a notification on a simple backup job to send an email
> to the operator when the job completes.
> However, the email is never sent out when the job completes. I have
> checked the operator history and there is no history of an email ever
> being sent. I also checked the current log and there are no error
> messages whatsover regarding the mail not being sent. I also checked
> the application log on node 1, and there is no error there either.
> I have run the backup job several times now, sent myself another test
> email from the server (which works fine), but for some reason the email
> just won't send on job completion.
> Has anyone had this problem and how to resolve it? I though restarting
> the Agent would solve the problem, but it has not.
> Thanks
|||If you are installed on a 64-bit platform, you will need to continue to use
SQL Mail and Outlook Express as your SMTP client.
How to configure SQL Server Agent to send job status notifications and alert
notifications in SQL Server 2005 64-bit editions
http://support.microsoft.com/kb/908360
Anthony Thomas
<tootsuite@.gmail.com> wrote in message
news:1162832443.165881.76790@.i42g2000cwa.googlegro ups.com...
> Hello,
> re: SQL Server 2005, SP1
> I set up Database Mail on a clustered server using the db mail wizard
> in Management Studio. I set up an operator using a mail group. The test
> email worked fine. I also restarted the SQL Server Agent on node 1 of
> the cluster (twice).
> Next, I set up a notification on a simple backup job to send an email
> to the operator when the job completes.
> However, the email is never sent out when the job completes. I have
> checked the operator history and there is no history of an email ever
> being sent. I also checked the current log and there are no error
> messages whatsover regarding the mail not being sent. I also checked
> the application log on node 1, and there is no error there either.
> I have run the backup job several times now, sent myself another test
> email from the server (which works fine), but for some reason the email
> just won't send on job completion.
> Has anyone had this problem and how to resolve it? I though restarting
> the Agent would solve the problem, but it has not.
> Thanks
>
re: SQL Server 2005, SP1
I set up Database Mail on a clustered server using the db mail wizard
in Management Studio. I set up an operator using a mail group. The test
email worked fine. I also restarted the SQL Server Agent on node 1 of
the cluster (twice).
Next, I set up a notification on a simple backup job to send an email
to the operator when the job completes.
However, the email is never sent out when the job completes. I have
checked the operator history and there is no history of an email ever
being sent. I also checked the current log and there are no error
messages whatsover regarding the mail not being sent. I also checked
the application log on node 1, and there is no error there either.
I have run the backup job several times now, sent myself another test
email from the server (which works fine), but for some reason the email
just won't send on job completion.
Has anyone had this problem and how to resolve it? I though restarting
the Agent would solve the problem, but it has not.
Thanks
I would check 2 things:
In Surface Configuration, is Database mail enabled
When you used the wizard to setup database mail, you had to create a
profle. Is that profile set as the "default"?
tootsuite@.gmail.com wrote:
> Hello,
> re: SQL Server 2005, SP1
> I set up Database Mail on a clustered server using the db mail wizard
> in Management Studio. I set up an operator using a mail group. The test
> email worked fine. I also restarted the SQL Server Agent on node 1 of
> the cluster (twice).
> Next, I set up a notification on a simple backup job to send an email
> to the operator when the job completes.
> However, the email is never sent out when the job completes. I have
> checked the operator history and there is no history of an email ever
> being sent. I also checked the current log and there are no error
> messages whatsover regarding the mail not being sent. I also checked
> the application log on node 1, and there is no error there either.
> I have run the backup job several times now, sent myself another test
> email from the server (which works fine), but for some reason the email
> just won't send on job completion.
> Has anyone had this problem and how to resolve it? I though restarting
> the Agent would solve the problem, but it has not.
> Thanks
|||If you are installed on a 64-bit platform, you will need to continue to use
SQL Mail and Outlook Express as your SMTP client.
How to configure SQL Server Agent to send job status notifications and alert
notifications in SQL Server 2005 64-bit editions
http://support.microsoft.com/kb/908360
Anthony Thomas
<tootsuite@.gmail.com> wrote in message
news:1162832443.165881.76790@.i42g2000cwa.googlegro ups.com...
> Hello,
> re: SQL Server 2005, SP1
> I set up Database Mail on a clustered server using the db mail wizard
> in Management Studio. I set up an operator using a mail group. The test
> email worked fine. I also restarted the SQL Server Agent on node 1 of
> the cluster (twice).
> Next, I set up a notification on a simple backup job to send an email
> to the operator when the job completes.
> However, the email is never sent out when the job completes. I have
> checked the operator history and there is no history of an email ever
> being sent. I also checked the current log and there are no error
> messages whatsover regarding the mail not being sent. I also checked
> the application log on node 1, and there is no error there either.
> I have run the backup job several times now, sent myself another test
> email from the server (which works fine), but for some reason the email
> just won't send on job completion.
> Has anyone had this problem and how to resolve it? I though restarting
> the Agent would solve the problem, but it has not.
> Thanks
>
Email notification does not send
Hello,
re: SQL Server 2005, SP1
I set up Database Mail on a clustered server using the db mail wizard
in Management Studio. I set up an operator using a mail group. The test
email worked fine. I also restarted the SQL Server Agent on node 1 of
the cluster using services manager.
Next, I set up a notification on a simple backup job to send an email
to the operator when the job completes.
However, the email is never sent out when the job completes. I have
checked the operator history and there is no history of an email ever
being sent. I also checked the current log and there are no error
messages whatsover regarding the mail not being sent. I also checked
the application log on node 1, and there is no error there either.
I have run the backup job several times now, send myself another test
email from the server (which works fine), but for some reason the email
just won't send on job completion.
Has anyone had this problem and how to resolve it? I though restarting
the Agent would solve the problem, but it has not.
Thanks
I have run into the same problem. I use sp_send_dbmail and run this step at
the end of my job:
EXEC msdb.dbo.sp_send_dbmail
@.profile_name = 'Hilary',
@.recipients = 'myemail@.myemail.com,
@.query = 'exec master.dbo.xp_fixeddrives' ,
@.subject = 'Disk Space from MyDB'
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
<tootsuite@.gmail.com> wrote in message
news:1162832367.375831.237680@.h48g2000cwc.googlegr oups.com...
> Hello,
> re: SQL Server 2005, SP1
> I set up Database Mail on a clustered server using the db mail wizard
> in Management Studio. I set up an operator using a mail group. The test
> email worked fine. I also restarted the SQL Server Agent on node 1 of
> the cluster using services manager.
> Next, I set up a notification on a simple backup job to send an email
> to the operator when the job completes.
> However, the email is never sent out when the job completes. I have
> checked the operator history and there is no history of an email ever
> being sent. I also checked the current log and there are no error
> messages whatsover regarding the mail not being sent. I also checked
> the application log on node 1, and there is no error there either.
> I have run the backup job several times now, send myself another test
> email from the server (which works fine), but for some reason the email
> just won't send on job completion.
> Has anyone had this problem and how to resolve it? I though restarting
> the Agent would solve the problem, but it has not.
> Thanks
>
re: SQL Server 2005, SP1
I set up Database Mail on a clustered server using the db mail wizard
in Management Studio. I set up an operator using a mail group. The test
email worked fine. I also restarted the SQL Server Agent on node 1 of
the cluster using services manager.
Next, I set up a notification on a simple backup job to send an email
to the operator when the job completes.
However, the email is never sent out when the job completes. I have
checked the operator history and there is no history of an email ever
being sent. I also checked the current log and there are no error
messages whatsover regarding the mail not being sent. I also checked
the application log on node 1, and there is no error there either.
I have run the backup job several times now, send myself another test
email from the server (which works fine), but for some reason the email
just won't send on job completion.
Has anyone had this problem and how to resolve it? I though restarting
the Agent would solve the problem, but it has not.
Thanks
I have run into the same problem. I use sp_send_dbmail and run this step at
the end of my job:
EXEC msdb.dbo.sp_send_dbmail
@.profile_name = 'Hilary',
@.recipients = 'myemail@.myemail.com,
@.query = 'exec master.dbo.xp_fixeddrives' ,
@.subject = 'Disk Space from MyDB'
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
<tootsuite@.gmail.com> wrote in message
news:1162832367.375831.237680@.h48g2000cwc.googlegr oups.com...
> Hello,
> re: SQL Server 2005, SP1
> I set up Database Mail on a clustered server using the db mail wizard
> in Management Studio. I set up an operator using a mail group. The test
> email worked fine. I also restarted the SQL Server Agent on node 1 of
> the cluster using services manager.
> Next, I set up a notification on a simple backup job to send an email
> to the operator when the job completes.
> However, the email is never sent out when the job completes. I have
> checked the operator history and there is no history of an email ever
> being sent. I also checked the current log and there are no error
> messages whatsover regarding the mail not being sent. I also checked
> the application log on node 1, and there is no error there either.
> I have run the backup job several times now, send myself another test
> email from the server (which works fine), but for some reason the email
> just won't send on job completion.
> Has anyone had this problem and how to resolve it? I though restarting
> the Agent would solve the problem, but it has not.
> Thanks
>
Email notification does not send
Hello,
re: SQL Server 2005, SP1
I set up Database Mail on a clustered server using the db mail wizard
in Management Studio. I set up an operator using a mail group. The test
email worked fine. I also restarted the SQL Server Agent on node 1 of
the cluster using services manager.
Next, I set up a notification on a simple backup job to send an email
to the operator when the job completes.
However, the email is never sent out when the job completes. I have
checked the operator history and there is no history of an email ever
being sent. I also checked the current log and there are no error
messages whatsover regarding the mail not being sent. I also checked
the application log on node 1, and there is no error there either.
I have run the backup job several times now, send myself another test
email from the server (which works fine), but for some reason the email
just won't send on job completion.
Has anyone had this problem and how to resolve it? I though restarting
the Agent would solve the problem, but it has not.
ThanksI have run into the same problem. I use sp_send_dbmail and run this step at
the end of my job:
EXEC msdb.dbo.sp_send_dbmail
@.profile_name = 'Hilary',
@.recipients = 'myemail@.myemail.com,
@.query = 'exec master.dbo.xp_fixeddrives' ,
@.subject = 'Disk Space from MyDB'
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
<tootsuite@.gmail.com> wrote in message
news:1162832367.375831.237680@.h48g2000cwc.googlegroups.com...
> Hello,
> re: SQL Server 2005, SP1
> I set up Database Mail on a clustered server using the db mail wizard
> in Management Studio. I set up an operator using a mail group. The test
> email worked fine. I also restarted the SQL Server Agent on node 1 of
> the cluster using services manager.
> Next, I set up a notification on a simple backup job to send an email
> to the operator when the job completes.
> However, the email is never sent out when the job completes. I have
> checked the operator history and there is no history of an email ever
> being sent. I also checked the current log and there are no error
> messages whatsover regarding the mail not being sent. I also checked
> the application log on node 1, and there is no error there either.
> I have run the backup job several times now, send myself another test
> email from the server (which works fine), but for some reason the email
> just won't send on job completion.
> Has anyone had this problem and how to resolve it? I though restarting
> the Agent would solve the problem, but it has not.
> Thanks
>
re: SQL Server 2005, SP1
I set up Database Mail on a clustered server using the db mail wizard
in Management Studio. I set up an operator using a mail group. The test
email worked fine. I also restarted the SQL Server Agent on node 1 of
the cluster using services manager.
Next, I set up a notification on a simple backup job to send an email
to the operator when the job completes.
However, the email is never sent out when the job completes. I have
checked the operator history and there is no history of an email ever
being sent. I also checked the current log and there are no error
messages whatsover regarding the mail not being sent. I also checked
the application log on node 1, and there is no error there either.
I have run the backup job several times now, send myself another test
email from the server (which works fine), but for some reason the email
just won't send on job completion.
Has anyone had this problem and how to resolve it? I though restarting
the Agent would solve the problem, but it has not.
ThanksI have run into the same problem. I use sp_send_dbmail and run this step at
the end of my job:
EXEC msdb.dbo.sp_send_dbmail
@.profile_name = 'Hilary',
@.recipients = 'myemail@.myemail.com,
@.query = 'exec master.dbo.xp_fixeddrives' ,
@.subject = 'Disk Space from MyDB'
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
<tootsuite@.gmail.com> wrote in message
news:1162832367.375831.237680@.h48g2000cwc.googlegroups.com...
> Hello,
> re: SQL Server 2005, SP1
> I set up Database Mail on a clustered server using the db mail wizard
> in Management Studio. I set up an operator using a mail group. The test
> email worked fine. I also restarted the SQL Server Agent on node 1 of
> the cluster using services manager.
> Next, I set up a notification on a simple backup job to send an email
> to the operator when the job completes.
> However, the email is never sent out when the job completes. I have
> checked the operator history and there is no history of an email ever
> being sent. I also checked the current log and there are no error
> messages whatsover regarding the mail not being sent. I also checked
> the application log on node 1, and there is no error there either.
> I have run the backup job several times now, send myself another test
> email from the server (which works fine), but for some reason the email
> just won't send on job completion.
> Has anyone had this problem and how to resolve it? I though restarting
> the Agent would solve the problem, but it has not.
> Thanks
>
Email notification does not send
Hello,
re: SQL Server 2005, SP1
I set up Database Mail on a clustered server using the db mail wizard
in Management Studio. I set up an operator using a mail group. The test
email worked fine. I also restarted the SQL Server Agent on node 1 of
the cluster using services manager.
Next, I set up a notification on a simple backup job to send an email
to the operator when the job completes.
However, the email is never sent out when the job completes. I have
checked the operator history and there is no history of an email ever
being sent. I also checked the current log and there are no error
messages whatsover regarding the mail not being sent. I also checked
the application log on node 1, and there is no error there either.
I have run the backup job several times now, send myself another test
email from the server (which works fine), but for some reason the email
just won't send on job completion.
Has anyone had this problem and how to resolve it? I though restarting
the Agent would solve the problem, but it has not.
ThanksI have run into the same problem. I use sp_send_dbmail and run this step at
the end of my job:
EXEC msdb.dbo.sp_send_dbmail
@.profile_name = 'Hilary',
@.recipients = 'myemail@.myemail.com,
@.query = 'exec master.dbo.xp_fixeddrives' ,
@.subject = 'Disk Space from MyDB'
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
<tootsuite@.gmail.com> wrote in message
news:1162832367.375831.237680@.h48g2000cwc.googlegroups.com...
> Hello,
> re: SQL Server 2005, SP1
> I set up Database Mail on a clustered server using the db mail wizard
> in Management Studio. I set up an operator using a mail group. The test
> email worked fine. I also restarted the SQL Server Agent on node 1 of
> the cluster using services manager.
> Next, I set up a notification on a simple backup job to send an email
> to the operator when the job completes.
> However, the email is never sent out when the job completes. I have
> checked the operator history and there is no history of an email ever
> being sent. I also checked the current log and there are no error
> messages whatsover regarding the mail not being sent. I also checked
> the application log on node 1, and there is no error there either.
> I have run the backup job several times now, send myself another test
> email from the server (which works fine), but for some reason the email
> just won't send on job completion.
> Has anyone had this problem and how to resolve it? I though restarting
> the Agent would solve the problem, but it has not.
> Thanks
>
re: SQL Server 2005, SP1
I set up Database Mail on a clustered server using the db mail wizard
in Management Studio. I set up an operator using a mail group. The test
email worked fine. I also restarted the SQL Server Agent on node 1 of
the cluster using services manager.
Next, I set up a notification on a simple backup job to send an email
to the operator when the job completes.
However, the email is never sent out when the job completes. I have
checked the operator history and there is no history of an email ever
being sent. I also checked the current log and there are no error
messages whatsover regarding the mail not being sent. I also checked
the application log on node 1, and there is no error there either.
I have run the backup job several times now, send myself another test
email from the server (which works fine), but for some reason the email
just won't send on job completion.
Has anyone had this problem and how to resolve it? I though restarting
the Agent would solve the problem, but it has not.
ThanksI have run into the same problem. I use sp_send_dbmail and run this step at
the end of my job:
EXEC msdb.dbo.sp_send_dbmail
@.profile_name = 'Hilary',
@.recipients = 'myemail@.myemail.com,
@.query = 'exec master.dbo.xp_fixeddrives' ,
@.subject = 'Disk Space from MyDB'
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
<tootsuite@.gmail.com> wrote in message
news:1162832367.375831.237680@.h48g2000cwc.googlegroups.com...
> Hello,
> re: SQL Server 2005, SP1
> I set up Database Mail on a clustered server using the db mail wizard
> in Management Studio. I set up an operator using a mail group. The test
> email worked fine. I also restarted the SQL Server Agent on node 1 of
> the cluster using services manager.
> Next, I set up a notification on a simple backup job to send an email
> to the operator when the job completes.
> However, the email is never sent out when the job completes. I have
> checked the operator history and there is no history of an email ever
> being sent. I also checked the current log and there are no error
> messages whatsover regarding the mail not being sent. I also checked
> the application log on node 1, and there is no error there either.
> I have run the backup job several times now, send myself another test
> email from the server (which works fine), but for some reason the email
> just won't send on job completion.
> Has anyone had this problem and how to resolve it? I though restarting
> the Agent would solve the problem, but it has not.
> Thanks
>
E-mail Notification
We are running SQL 2000 Enterprise Edition under Windows 2003 Standard
Edition Server. We setup some maintenance jobs under Database Maintenance
and would like to setup e-mail notification. When we setup notifications,
we got the following error message: "Error 22022: SQLServerAgent Error:
The SQLServer Agent mail session is not running; check the mail profile
and/or the SQLServerAgent service startup account in the SQLServerAgent
Properties dialog." What do we need to do? Please let us know if you need
additional information. Thank you.
You have to interactively login as thye service account that SQL is running
under and install Outlook and configure a mapi profile. If you are still
running as localsystem, you'll need to switch to a service account for it to
work. The SQL Server service account maust have rights to access the mapi
profile.
"Diane Walker" wrote:
> We are running SQL 2000 Enterprise Edition under Windows 2003 Standard
> Edition Server. We setup some maintenance jobs under Database Maintenance
> and would like to setup e-mail notification. When we setup notifications,
> we got the following error message: "Error 22022: SQLServerAgent Error:
> The SQLServer Agent mail session is not running; check the mail profile
> and/or the SQLServerAgent service startup account in the SQLServerAgent
> Properties dialog." What do we need to do? Please let us know if you need
> additional information. Thank you.
>
>
|||Thanks very much for your prompt response, Jeffrey.
"Jeffrey K. Ericson" <JeffreyKEricson@.discussions.microsoft.com> wrote in
message news:3DBDB121-D7D6-413C-BF3F-1B1F33CEDB4D@.microsoft.com...[vbcol=seagreen]
> You have to interactively login as thye service account that SQL is
> running
> under and install Outlook and configure a mapi profile. If you are still
> running as localsystem, you'll need to switch to a service account for it
> to
> work. The SQL Server service account maust have rights to access the mapi
> profile.
> "Diane Walker" wrote:
Edition Server. We setup some maintenance jobs under Database Maintenance
and would like to setup e-mail notification. When we setup notifications,
we got the following error message: "Error 22022: SQLServerAgent Error:
The SQLServer Agent mail session is not running; check the mail profile
and/or the SQLServerAgent service startup account in the SQLServerAgent
Properties dialog." What do we need to do? Please let us know if you need
additional information. Thank you.
You have to interactively login as thye service account that SQL is running
under and install Outlook and configure a mapi profile. If you are still
running as localsystem, you'll need to switch to a service account for it to
work. The SQL Server service account maust have rights to access the mapi
profile.
"Diane Walker" wrote:
> We are running SQL 2000 Enterprise Edition under Windows 2003 Standard
> Edition Server. We setup some maintenance jobs under Database Maintenance
> and would like to setup e-mail notification. When we setup notifications,
> we got the following error message: "Error 22022: SQLServerAgent Error:
> The SQLServer Agent mail session is not running; check the mail profile
> and/or the SQLServerAgent service startup account in the SQLServerAgent
> Properties dialog." What do we need to do? Please let us know if you need
> additional information. Thank you.
>
>
|||Thanks very much for your prompt response, Jeffrey.
"Jeffrey K. Ericson" <JeffreyKEricson@.discussions.microsoft.com> wrote in
message news:3DBDB121-D7D6-413C-BF3F-1B1F33CEDB4D@.microsoft.com...[vbcol=seagreen]
> You have to interactively login as thye service account that SQL is
> running
> under and install Outlook and configure a mapi profile. If you are still
> running as localsystem, you'll need to switch to a service account for it
> to
> work. The SQL Server service account maust have rights to access the mapi
> profile.
> "Diane Walker" wrote:
E-mail Notification
We are running SQL 2000 Enterprise Edition under Windows 2003 Standard
Edition Server. We setup some maintenance jobs under Database Maintenance
and would like to setup e-mail notification. When we setup notifications,
we got the following error message: "Error 22022: SQLServerAgent Error:
The SQLServer Agent mail session is not running; check the mail profile
and/or the SQLServerAgent service startup account in the SQLServerAgent
Properties dialog." What do we need to do? Please let us know if you need
additional information. Thank you.You have to interactively login as thye service account that SQL is running
under and install Outlook and configure a mapi profile. If you are still
running as localsystem, you'll need to switch to a service account for it to
work. The SQL Server service account maust have rights to access the mapi
profile.
"Diane Walker" wrote:
> We are running SQL 2000 Enterprise Edition under Windows 2003 Standard
> Edition Server. We setup some maintenance jobs under Database Maintenance
> and would like to setup e-mail notification. When we setup notifications,
> we got the following error message: "Error 22022: SQLServerAgent Error:
> The SQLServer Agent mail session is not running; check the mail profile
> and/or the SQLServerAgent service startup account in the SQLServerAgent
> Properties dialog." What do we need to do? Please let us know if you nee
d
> additional information. Thank you.
>
>|||Thanks very much for your prompt response, Jeffrey.
"Jeffrey K. Ericson" <JeffreyKEricson@.discussions.microsoft.com> wrote in
message news:3DBDB121-D7D6-413C-BF3F-1B1F33CEDB4D@.microsoft.com...[vbcol=seagreen]
> You have to interactively login as thye service account that SQL is
> running
> under and install Outlook and configure a mapi profile. If you are still
> running as localsystem, you'll need to switch to a service account for it
> to
> work. The SQL Server service account maust have rights to access the mapi
> profile.
> "Diane Walker" wrote:
>
Edition Server. We setup some maintenance jobs under Database Maintenance
and would like to setup e-mail notification. When we setup notifications,
we got the following error message: "Error 22022: SQLServerAgent Error:
The SQLServer Agent mail session is not running; check the mail profile
and/or the SQLServerAgent service startup account in the SQLServerAgent
Properties dialog." What do we need to do? Please let us know if you need
additional information. Thank you.You have to interactively login as thye service account that SQL is running
under and install Outlook and configure a mapi profile. If you are still
running as localsystem, you'll need to switch to a service account for it to
work. The SQL Server service account maust have rights to access the mapi
profile.
"Diane Walker" wrote:
> We are running SQL 2000 Enterprise Edition under Windows 2003 Standard
> Edition Server. We setup some maintenance jobs under Database Maintenance
> and would like to setup e-mail notification. When we setup notifications,
> we got the following error message: "Error 22022: SQLServerAgent Error:
> The SQLServer Agent mail session is not running; check the mail profile
> and/or the SQLServerAgent service startup account in the SQLServerAgent
> Properties dialog." What do we need to do? Please let us know if you nee
d
> additional information. Thank you.
>
>|||Thanks very much for your prompt response, Jeffrey.
"Jeffrey K. Ericson" <JeffreyKEricson@.discussions.microsoft.com> wrote in
message news:3DBDB121-D7D6-413C-BF3F-1B1F33CEDB4D@.microsoft.com...[vbcol=seagreen]
> You have to interactively login as thye service account that SQL is
> running
> under and install Outlook and configure a mapi profile. If you are still
> running as localsystem, you'll need to switch to a service account for it
> to
> work. The SQL Server service account maust have rights to access the mapi
> profile.
> "Diane Walker" wrote:
>
Subscribe to:
Posts (Atom)