August 29, 2013 at 10:14 am
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.
August 29, 2013 at 11:38 am
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.
August 30, 2013 at 1:36 am
Take application development team help and alert in email.
Regards
Durai Nagarajan
August 30, 2013 at 4:58 am
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
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 30, 2013 at 5:12 am
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
August 30, 2013 at 5:23 am
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
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 30, 2013 at 5:41 am
OH great , i am out of mind , this didnt strike great thought
Regards
Durai Nagarajan
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply