SQL Server Agent Issues - Needed Help

• SQLDBA-493259

  SSC Journeyman

  Points: 98

  More actions

  September 21, 2007 at 5:30 am

  #91350

  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

• Antares686

  SSC Guru

  Points: 125444

  More actions

  September 21, 2007 at 7:28 am

  #735225

  Please do not cross post. See my response in your other thread http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=110&messageid=401086#bm401135