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

how to create the alerts for services Expand / Collapse
Author
Message
Posted Thursday, August 29, 2013 10:14 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 10:10 PM
Points: 147, Visits: 419
Hi all.

here in my environment we are not using any monitoring tools for alerts.

we are planning to create the alerts. if the services are down we need a alert message. how can i configure the alerts without monitoring tool.
Post #1489791
Posted Thursday, August 29, 2013 11:38 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Yesterday @ 12:17 PM
Points: 737, Visits: 5,460
Without installing some sort of monitoring tool, you're pretty much limited to setting up a Windows Scheduled Task, and a script to check if the service(s) are running. Downside, there will be a delay between the service failing, and the alert triggering, depending on how frequently the task runs.

Probably the best option for the script would be to look into Powershell. Start with the Get-Service cmdlet, and go from there.
Post #1489820
Posted Friday, August 30, 2013 1:36 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, October 28, 2014 10:45 AM
Points: 1,058, Visits: 2,696
Take application development team help and alert in email.

Regards
Durai Nagarajan
Post #1490019
Posted Friday, August 30, 2013 4:58 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 10:07 AM
Points: 14,034, Visits: 28,406
It's not the best possible solution, but you can set up Alerts within SQL Agent. Here's the Books Online example of how to get it done.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server Query Performance Tuning
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1490076
Posted Friday, August 30, 2013 5:12 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, October 28, 2014 10:45 AM
Points: 1,058, Visits: 2,696
Grant already you informed that it is not the best solution, my question is what if agent is down.

we definetely need a service out of SQL to monitor these. hopw you agree


Regards
Durai Nagarajan
Post #1490079
Posted Friday, August 30, 2013 5:23 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 10:07 AM
Points: 14,034, Visits: 28,406
durai nagarajan (8/30/2013)
Grant already you informed that it is not the best solution, my question is what if agent is down.

we definetely need a service out of SQL to monitor these. hopw you agree


Apologies. You didn't mention SQL Agent, so I didn't realize that's what you meant.

It's a question of another service on another server to monitor the monitor. You can use a different SQL Agent to monitor the first one. You can set up a Policy Based Management process on another server to monitor the Agent. You can write a PowerShell script that connects/disconnects in a loop and the first time it can't connect, it sends you an email. You have lots of choices.


----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server Query Performance Tuning
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1490085
Posted Friday, August 30, 2013 5:41 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, October 28, 2014 10:45 AM
Points: 1,058, Visits: 2,696
OH great , i am out of mind , this didnt strike great thought

Regards
Durai Nagarajan
Post #1490089
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse