September 21, 2007 at 5:48 am
Hi,
I am a DBA and I having an issue with the SQl server agent being down for 5 minutes and restart every night automatically around the same time.Getting IP monitor alerts during that time .
Alert 1: the last test (Thu, 20 Sep 2007 22:05:39 -0400) reported the following status:
Call was canceled by the message filter; oserror: 0x80010002
This monitor:
----------------------------
- has been down for 5.00 minutes
- has an availability rating of: 99.39%
- has experienced 3 consecutive failures
- has experienced 3 failures unrelated to specified dependencies
- requires 3 of these critical failures to trigger an alert
- will trigger a maximum of 5 alerts
Any body knows what 's going on ? what it would be ..a sql issue or hardware issue ?
Any help would be appreciated.
Regards,
SQLDBA
Regards,
SQLDBA
September 21, 2007 at 7:27 am
Did you check the EventViewer logs to see if anything unusual around the same time in them?
September 21, 2007 at 7:29 am
yeap..I checked sql logs, I don't see any.I checked application and system logs ,I saw some error messages in system logs but not sure whether they are related to this issue.
Regards,
SQLDBA
September 21, 2007 at 7:46 am
Could be something in one of the jobs specifically doing it, maybe throwing an unmaged error and crashing SQL Agent. Look at all the jobs that run around that time and look at the errors you saw in event viewer, see if there is any correlation. I would expect either a DTS package (maybe a bad reference) or an executed task (basically anything that is not Transact-SQL).
September 21, 2007 at 7:50 am
There are no jobs running at that time.
Regards,
SQLDBA
September 21, 2007 at 8:40 am
I saw some termservice device errors around the same time everyday.Not sure what they are.
Regards,
SQLDBA
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply