| Author |
Topic |
|
krajdba
Starting Member
43 Posts |
 Posted - 2007-09-26 : 08:32:53
|
| Hi I am creating Alerts for MSSQLServer service shutdown. Could you please let me know the error of this.Urgent please.ThanksRaj. |
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-09-26 : 08:51:21
|
Krajdba, I don't understand your question? Are you looking for the event ID for MSSQL Server service shutdown? 17148 is the number in the information message, 17055 is the eventID.
Future guru in the making. |
 |
|
|
krajdba
Starting Member
43 Posts |
Posted - 2007-09-27 : 04:40:38
|
| Hi Zoroaster,Can I use 17055 as error number for Event alert definition in the Alert setup?ThanksRaj. |
|
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-09-27 : 08:52:32
|
quote:
Originally posted by krajdba
Hi Zoroaster,Can I use 17055 as error number for Event alert definition in the Alert setup?ThanksRaj.
What are you using to monitor the Event? Are you using third party tools or SQL Agent? The event ID specifically would be 17148 for stopping SQL Server Service but that is from an intentional stop and I'm not sure it's very useful information.
Future guru in the making. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-28 : 01:04:40
|
| Sql agent goes down before sql service, so you can't send sql alert for sql down. |
|
|
|
krajdba
Starting Member
43 Posts |
Posted - 2007-09-28 : 06:21:31
|
| Hi Ok let me put the question this way. If the MSSQLServer service is shutdown.I would like to get a alert mail. How can I configure this.Please help very urgent.Raj. |
|
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-09-28 : 11:08:45
|
Under the Recovery tab in services you have an option to Run a program on first, second or third failure, this would be for anything but an expected shutdown. You can then call a script or a third party utility to send an alert email.
Future guru in the making. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-28 : 22:44:32
|
| Those are for sending alert when service failed to start. You need check windows app event log for service stop message. |
|
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-09-29 : 00:44:13
|
quote:
Originally posted by rmiao
Those are for sending alert when service failed to start. You need check windows app event log for service stop message.
Actually, it is when the service fails to start or if it fails period. Any unexpected shutdown will trigger the recovery actions.
Future guru in the making. |
|
|
|
krajdba
Starting Member
43 Posts |
Posted - 2007-10-01 : 05:31:43
|
| Great Thanks Zoroaster,Could you please give some URL or let me know about .....How to call a script or a third party utility to send an alert email?Thanks & RegardsRaj. |
|
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-10-01 : 09:09:57
|
From JSI tip website: 1. Press Start / Programs / Administrative Tools / Services.2. Double-click the service you wish to configure.3. On the Recovery tab, select from: Take No Action (the default) Restart the Service Run a File Reboot the ComputerIf you select Run a File, type one of the following: forcedos.exe <Drive:>\Folder\batchfile.bat wscript.exe <Drive:>\Folder\VBscriptfile.vbs wscript.exe <Drive:>\Folder\JAVAscriptfile.jsPress OK and exit the Services Manager.NOTE: Monitoring for failures requires minimal overhead as the Event log entries are monitored instead of polling the service status.You'll need to script the file to send an email using smtp or mapi and put in the message of your choosing. You can probably find a send mail script on http://www.4guysfromrolla.com/ or the one Microsoft provides vis the IIS SMTP service is here: http://support.microsoft.com/kb/193685
Future guru in the making. |
|
|
|
|
MSSQLServer service Down Error number