All,
When i needed to use email notifications in the past with a sql cluster I had to "forward" events and messages to a non clustered server with a MAPI client installed. This is because outlook 2000 and previous was not cluster aware.
Does anyone know if Outlook 2003 is cluster aware?
Does anyone have a better alternative to using outlook for SQL email notofication? For a cluster?
TIA
Outlook 2003 is not cluster aware.
Try xpsmtp from www.sqldev.net as an alternative.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Detroit" <anonymous@.discussions.microsoft.com> wrote in message
news:74F273D8-E837-4640-B3A1-E11AF06CBE36@.microsoft.com...
> All,
> When i needed to use email notifications in the past with a sql cluster I
had to "forward" events and messages to a non clustered server with a MAPI
client installed. This is because outlook 2000 and previous was not cluster
aware.
> Does anyone know if Outlook 2003 is cluster aware?
> Does anyone have a better alternative to using outlook for SQL email
notofication? For a cluster?
> TIA
|||Detroit,
Blat is a command line E-Mail program that is relatively easy to use. You should be able to create a batch process to accomplish this.
Bob G.
Showing posts with label clustered. Show all posts
Showing posts with label clustered. Show all posts
Monday, March 19, 2012
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 (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
>
Friday, February 17, 2012
Effect on snapshots while reindexing
Does someone know if doing a reindex on a clustered or non-clustered index cause the snapshot file to grow? In other words, is the data that makes up the snapshot copied from the source to the snapshot database? If a normal reindex is done on the underlying database, will it block users from acessing the snapshot? Any help would be appreciated.
All the pages changed by the reindexing would be pushed to the snapshot so its files would grow. It should not cause any blocking in the snapshot, though there can be a significant increase in the IO load.
Subscribe to:
Posts (Atom)