Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Pager alerts Expand / Collapse
Author
Message
Posted Tuesday, November 3, 2009 10:20 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, February 27, 2014 10:41 AM
Points: 361, Visits: 1,781
Hi, We are planning to third party monitoring tool (Probably Idera SQL DM). We also checked other tools, but all tools has option of setting up email alerts. We require a pager alerts. Please advice.

Do we contact any pager company like email alerts go to them and throw pager alerts. Licence and maintain details?
Post #813079
Posted Tuesday, November 3, 2009 10:26 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 5:32 PM
Points: 20,798, Visits: 32,714
People still have pagers??

If you already have the pager(s) check with the company and see if you can send email alerts via them. Many years ago at another company we had pagers and all we did is send an email to our pagers if there was a problem.




Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #813085
Posted Tuesday, November 3, 2009 10:32 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, February 27, 2014 10:41 AM
Points: 361, Visits: 1,781
Lynn Pettis (11/3/2009)
People still have pagers??

If you already have the pager(s) check with the company and see if you can send email alerts via them. Many years ago at another company we had pagers and all we did is send an email to our pagers if there was a problem.



We don't have pager. With email alerts we can't monitor 24X7. Every time DBA needs to check email in the off hours and weekend. That is why I asked about pager alerts. Is there any other way to monitor othar than pager alerts.

How did you set up pager alerts in your previous company, what's the process
Post #813089
Posted Tuesday, November 3, 2009 10:41 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 5:32 PM
Points: 20,798, Visits: 32,714
I don't remember the details as I haven't been there for over 4 years. We are looking at setting email alerts here to go to our cell phones. Haven't implemented it yet as we have several things we need to put in place first.

If you have cell phones with text messaging, check with your provider to see how you can do that. Each company has a different way if implementing the process.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #813098
Posted Tuesday, November 3, 2009 10:51 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:48 AM
Points: 12,921, Visits: 32,285
with att for example, i send a plaintext email my attphone: the address is your 10-digit number@txt.att.net.

ie email 9545551212@txt.att.net


Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #813104
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse