Alerts By Email In Clusterd Env.

Aug 9, 2001

Does anyone know of a way, either by 3rd party tools or using SQL server, to have alerts get emailed to you in a clustered active/active environment? I work as the DBA at a quickly-growing company, whose production databases need to be online 24X7. I want to set up the alerts to email/page me if there are problems with the databases, but since (according to microsoft) SQL mail is not supported in a clustered environment I'm at a loss.

I'm looking for some help in trying to resolve this issue either by 3rd party means or a SQL Server work around.

Your help will be greatly appreciated.

Sincerely,

Tony

View 1 Replies


ADVERTISEMENT

Email Alerts On Cluster...

May 8, 2002

We are in the process of setting up a SQL Server 2000 cluster, but have been told that MAPI email is not cluster aware so we can't use the alert system.

Has anyone got any idea how to get round this or how to set up alerts in another way (eg: when a backup fails, can we send smtp mail?) etc

any feedback would be appreciated.

Regards

Steve

View 1 Replies View Related

SQL Alerts Via Exchange Email

Dec 9, 1998

I once had a procedure to setup exchange client as email for SQL alerts,
but I've misplaced it. (threw it out, actually) I've not had great luck finding it on the web at MS, or otherwise. Does anyone know where this can be found? Thanks in advance, John

View 1 Replies View Related

Easier Email Alerts From Sql 7/2000?

Oct 5, 2006

hi,

i get just as frustrated each time i try to configure email alerts on failed jobs on ms sql, it is beyond me why microsoft couldn't just let you point out an SMTP server to send through and be done with it.

is there a way to avoid having to setup an email client on our sql 7 and 2000 servers through some 3rd party app or other simple solution?

thanks in advance,
daniel

View 2 Replies View Related

Email Alerts On Report Errors?

Oct 17, 2007

Is there any way I can configure Reporting Services to send me an error email should an error be encountered when rendering a report?

Thanks In Advance,

Martin

View 3 Replies View Related

Sending Alerts ,Email Notifications From SQL To CellPhone

Sep 4, 2001

HI,
Does any one know how I could send all the alerts, email notifications from the SQL Server to my Sprint PCS Phone. Is there any software for that. I know that it can be done by MSN mobile. Just checking whether it can be directly sent to my phone rather than going to hotmail which is then forwared to my cell phone. Let me know.
Thanks,
Cinday

View 1 Replies View Related

Getting Email Alerts For Specific SQL Errror Log Messages

May 29, 2008

Running sql server 2000 sp4 on an 8 year old Server and a shaky SAN.
We have had 3 major outages (corrupted databases) and they are finally biting the bullet and ordering a new Server. The new server will not be in place for about 9 days so until then... limping along with what we have. Is there any way to have SQL Server send an email alert when a specific error occurrs and is logged in the SQL log?
These are the two errors that I want to alert on..
"Error: 823, Severity: 24, State: 2"
or
"I/O error (bad page ID) detected during read at offset"

is this possible?

View 1 Replies View Related

DB Engine :: Get Email Alerts When Schema Changes In All Databases

Sep 11, 2015

I need to create an alert for sending email alerts when schema changed in any databases.At my side: Server 2012 R2 enterprise.37 databases are there.

View 6 Replies View Related

Dropping A Non Clusterd Index

Jan 28, 2008

hai
can anyone give me the syntax to drop a non clustered index

View 1 Replies View Related

Database Problem Related Clusterd Data

Nov 23, 2005

Hello sirWe have a very huge database its around 6 lakh recordsare being stored in it.records are not being a sorted order so we checked allrecord field through clustering option in Sql server.when we usedclustering records are showing in sorted order but speed of database isvery slow .i want to know with clustering is there any implecation in databaseregading performance od data.Can any one give his views to solve thisproblem?and increase the performance of our database.thanks a lot

View 2 Replies View Related

Reporting Services :: Data Driven Email Subscription With Different Email Per Report Page

Jul 6, 2015

I have a report that gets sends out through a subscription and sometimes the report has multiple pages and all those pages appear within one email.Is it possible to set the subscription in such a way that an email is sent per page when the subscription executes.

View 2 Replies View Related

Dbmail Doesn't Rely On IIS SMTP, How To Set Bounced Email Redirect Email Etc.? Thanks

May 4, 2007

Under IIS SMTP I can set bounced email redirect etc. how to do that with dbmail, the idea is I can get the list of bounced emails somewhere so I can create a report.



Any idea?



thanks

View 2 Replies View Related

Help Split List Of Email Add Comma For Evry Email

May 12, 2008

need help
split list of email add comma for evry email
i have tabe "tblLogin" and in this table i have field emall
like this

emall
-----------------------------------------
aaa@hhhh.mm
nnn@hhhh.mm
mmm@hhhh.mm

need to do ilke this



Code Snippet
@list_email = (SELECT emall FROM tblLogin)

--------------------------i get this
-----------------------@list_email=aaa@hhhh.mm ; nnn@hhhh.mm ; mmm@hhhh.mm

@recipients = @list_email










Code Snippet

IF EXISTS( SELECT * FROM [db_all].[dbo].[taliB] )



BEGIN

DECLARE @xml NVARCHAR(MAX)DECLARE @body NVARCHAR(MAX)

SET @xml =CAST(( SELECT

FirstName AS 'td','',

LastName AS 'td','' ,

Date_born AS 'td','' ,

Age AS 'td','' ,

BirthdayToday AS 'td','' ,

BirthdayThisWeek AS 'td'

FROM [Bakra_all].[dbo].[taliB] ORDER BY LastName FOR XML PATH('tr'), ELEMENTS ) AS NVARCHAR(MAX))

SET @body ='<html><H1 align=center>aaaaaaaaaaaaaaaaaaaaaa</H1><body ><table border = 1 align=center dir=rtl>

<tr>

<td>name</td>

<td>fname</td>

<td>date</td>

<td>age</td>

<td>aaaaaaaaa</td>

<td>bbbbbbbbbbbbbbb</td>

</tr>'

SET @body = @body + @xml +'</table></body></html>'

EXEC msdb.dbo.sp_send_dbmail

@recipients =N'rrr@iec.co.il',

@copy_recipients='rrrrr@iec.co.il',

@body = @body,

@body_format ='HTML',

@subject ='ggggggggggggggggggggg',

@profile_name ='ilan'

END

ELSE

print 'no email today'

View 1 Replies View Related

SQL Alerts

Feb 9, 2000

Is there any recommendations on setting up Alerts. What are the standard set alerts that should be setup on every server?

View 1 Replies View Related

Help With Alerts

May 9, 2002

I have to send the alerts when the database(s) will be filled more than 90% and 95%. Please help me if you have some samples.

Thanks,
Rau

View 1 Replies View Related

Anyone Using SQL Alerts?

Jun 20, 2008

I ignored this nice little feature till now, probably because mail configuration complexities. Now that we have DB mail, it has become very smooth.

I just implemented an alert for log growth, and found that it works very well.

Any of you using, alerts for , other interesting events?


------------------------
I think, therefore I am - Rene Descartes

View 4 Replies View Related

Alerts

Jun 20, 2006

Hi everyone,
I also could not find any definition about Alerts and their purpose and usage.
Would you please explain it to me ??

Thanks

View 4 Replies View Related

Autogrow And Alerts

Oct 31, 2000

Is there a way that I can get SQL Server to tell me (Alert?) when it has grabbed another chunk of space for a database that has the "Automatically grow file" option set?

View 1 Replies View Related

SQL Server Alerts

Dec 2, 1999

I was wondering if anyone knew of some key error numbers that I should look for to fire alerts off of.

For example, ERROR 926 "Database cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server error log for more information."

I am looking for some key error messages (Error Numbers) like the one above that are good to initially setup within SQL Server for alerting Administrators of potential issues.

Thanks,

Peter

View 1 Replies View Related

New Babie On Alerts

Dec 4, 2002

Hi,
I just realized there are several severity alerts on the Server Agent, from Severity 19 to 25.
Is there anyways to delete those messages? If I don't delete those, would it be affected later?
The Online Book mentions those are some of the system error messages, but they don't show how to delete them.
Can anyone helps?
Thanks a lot.

View 6 Replies View Related

Locks And Alerts

Nov 3, 2005

Hi,

I am having trouble with locks and performance issues in one application. The SQL server is specific to this application. What settings should i choose to set an alert to let me know when i get too many locks? the locks i am interested in ar ethe ones that show up in SQL EM. ie where a process is blocking another process(es).

I have tried New Alert | lock requests /sec but that is a huge figure when the server is running OK, so i cant guess what value to set for the counter. Is there a better object/counter i should use?

thanks
fatherjack

View 5 Replies View Related

Alerts Not Being Triggered

Dec 14, 1998

I've setup alerts and an operator to email on a particular event code.
I can successfully test the operator. (It e-mails fine)
The problem I am having is that despite having a particular event
log to the NT application log, no SQL Alert is triggered.
I've tried logging to the NT Application log, as well as the SQL errorlog.
The SQLExecutive is running.
Thanks in advance.
John

View 1 Replies View Related

Alerts For Jobs

May 4, 2001

I am working with alerts and trying to see if there is a way that I can control the message on the notification. I have the job set to send an email and a net message when the job succeeds. Since this message will be going to the user, I owuld like to be able to make the message as clear as possible for them. Does anyone know if the message being sent can be modified or altered with an alert? And how?

Thanks!!

View 1 Replies View Related

MS SQL Operator Job Alerts Via SMS

Feb 17, 2005

Hey guys,
I was just thinking, is it possible to send alerts via the Managment/SQL Server Agent/Operators/Alerts to an SMS system?

Is it even technically posibble?

Actually I am trying to develop an alert system that reads the database table periodcally, the data being read is a datetime, once it reaches the time, I need to send an sms to the person.


Any suggestions? ideas? Quickest solution?

View 1 Replies View Related

Alerts Not Working

Mar 22, 2004

I defined an Alert in Enterprise Manager for Severity 19 - Fatal Error In Resource. The alert is enabled, the type is "sql server event alert" and the alert is defined against a specific database. SQLSERVERAGENT and SQL Mail session are both started. I test the alert using the following statement in the specified database.

raiserror (50001,19,1) with log

A message is placed in the SQL Server log, however no alert is fired. The alert history indicates the alert has never occurred. What am I missing?

Thanks, Dave

View 8 Replies View Related

Sql Server2005 -Alerts

May 29, 2008

hi
how are the use alerts in sql server2005,
and which alert type used in maximum and how to performaing our database

I would like to get user experiences

View 3 Replies View Related

Load A Text File With Email Addresses And Compare Against A Database Table That Has Email Addresses And User_id

Jul 12, 2007

Hello ALL



what I want to achieve is to load a text file that has email addreses from disk and using the email addresses in the text file look it up against the email addresses in the database table then once matched delete all the users in the table whose email address were in the text file.



I also want to update some users using a different text file.



Please help me with the best way to do this



Thanks in advance

View 6 Replies View Related

Sql Mail Alerts & Groupwise

Sep 28, 2001

Can anyone point me in the direction of a good resource
that will help us set up our system so that
notifications from alerts/jobs send emails to our
Groupwise email system?

View 1 Replies View Related

Notifications Sent Even If Alerts Are Disabled

Mar 7, 2001

Hello all,

Here's the problem I'm trying to solve:

I have several alerts set up and a job setup to notify via email if alerts occur. There are times when I might be doing maintenace on a box that may generate alerts but I don't want to get emailed or paged for these "dummy" alerts. I thought first of setting the enabled column of sysalerts to 0 - that doesn't work. I still get notified. Then I thought I'd set the enabled column in sysjobs for my notification job to 0 while I'm doing the work. But as soon as I re-enable the job I get an alert. It seems that as soon as the job is re-enabled it checks the NT application log and sees that an alert was fired and somehow knows that there was no notification sent so sends one. If I purge the NT application log before re-enabling the job is solves the problem. But that is a very in-ellegant solution and I don't want to loose all the info stored in the event log any way. Does anyone know how SQL SErver aggent keeps track of this stuff? (ie. that an alert was fired but it's response job is disabled and to check once a job is re-enabled to see if any alerts occured while it was disabled?) I did a Profiler trace while re-enabling the job but didn't see anything pertinant in there.

Thanks in advance.

Patrick

View 2 Replies View Related

Writing SQL Alerts - DB Out Of Space

Nov 30, 2000

I want to write a sql alert to notify me when my database is out of space.
So as not to duplicate any messages - has anyone seen threads on this subject?
If not, can anyone give ideas on how to create this script?
thanks in advance.

View 1 Replies View Related

User Alerts, Best Practice

Jun 3, 2004

I'm searching for tips on how to alert users regarding downtime of our SQL Server. Is it good enough to alert users by email, and then shut down the service, or do you use a better approach (lock database, sp_who, one-by-one alert...)?

Thankful for all replies.

Newbie in DB administration.

View 1 Replies View Related

Custom Alerts To Invoke A Job

Aug 19, 2004

I want to creat an alert that will back up my database when the log files get to 90% full. When i try to create a new alert and select performance condition and select sqlserver:databases as the object then log file(s) Used size (kb) as the counter but when i go and select the instance i dont see my database in the drop down list but if I change to sql server event alert I see the database i want to use for this alert. I dont want to wait until the log is already full to back it up i want to do it when it hits a percent full. Is there a way to do this as a performance condition? thanks for your help!

View 7 Replies View Related

SQL Server System Alerts

Feb 27, 2002

Maybe a dumb question, the standard alerts like Severity 24 and 25 that come when you install SQL Server, will these alerts be called by SQL Server itself if there is a problem. I was going to set up notifications for these but wasn't sure if it was worth the trouble.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved