August 11, 2014 at 6:44 am
HI Experts,
On my production server, the sql server was down for more than 6 hrs & happened on weekend, no one noticed it. Before customers login, I started the sql server Agent(failover cluster) and now all good.
I configured DB mail alert incase of any jobs failure, it triggers automated mail and in the same manner I want to configure for SQL Server service and SQL Server Agent service. I surfed net and checked it is possible only with powershell scripting and with some other third party tools as it a customer/production server, we are not allowed to do.
Is there any way to configure for the automatic mails in sql server, incase of any SQL Server service and Agent fails....
Its a Enterprise Edition, X64 , OS 2008R2 and configured in Cluster environment
Looking forward for your replies...
Thanks
Praneeth
August 12, 2014 at 1:03 am
This was removed by the editor as SPAM
August 12, 2014 at 1:31 am
praneethydba (8/11/2014)
HI Experts,On my production server, the sql server was down for more than 6 hrs & happened on weekend, no one noticed it. Before customers login, I started the sql server Agent(failover cluster) and now all good.
I configured DB mail alert incase of any jobs failure, it triggers automated mail and in the same manner I want to configure for SQL Server service and SQL Server Agent service. I surfed net and checked it is possible only with powershell scripting and with some other third party tools as it a customer/production server, we are not allowed to do.
Is there any way to configure for the automatic mails in sql server, incase of any SQL Server service and Agent fails....
Its a Enterprise Edition, X64 , OS 2008R2 and configured in Cluster environment
Looking forward for your replies...
Thanks
Praneeth
You would need something external to SQL to monitor the services, something like powershell, Spotlight, Idera, SQL Monitor, SCOM etc etc.
Powershell would be the easiest and cheapest to setup.
Would want to to use the Get-Service cmdlet, set the status to a variable and check if its running or not then send a mail.
August 12, 2014 at 2:06 pm
Firstly, your failover cluster failed. Research with your windows Administrator the cause for failure. Your HA needs to happen automatically without any human intervention (no waiting for even emails 😉
As Anthony mentioned, SQL Server and SQL Agent are just services running in your windows server. You need monitoring external to SQL Server to check its heart beat.
If SQL Server/Agent is not running, then it cannot send emails as a job. Its like sending email of 'connectivity issues' when the email server is down
August 13, 2014 at 10:17 am
HI,
I even checked the event viewer, nothing found. We are expecting because of Antivirus update on Production server, the issue occurred...
Thanks
Praneeth
August 13, 2014 at 2:14 pm
To view errors/warnings et al for Cluster failure , you need to view thru 'Cluster Failover Manager'. More information available at http://technet.microsoft.com/en-us/library/cc772342.aspx
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply