InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 16:38:32 GMT20http://www.sqlservercentral.com/Forums/Topic1393145-1550-1.aspxYes, this is what in that file:But there is also SQLAGENT.OUT that has the following information:2012-12-05 04:13:22 - ? [100] Microsoft SQLServerAgent version 10.50.2500.0 (x86 unicode retail build) : Process ID 159842012-12-05 04:13:22 - ? [101] SQL Server Myservername version 10.50.2500 (0 connection limit)2012-12-05 04:13:22 - ? [102] SQL Server ODBC driver version 10.50.25002012-12-05 04:13:22 - ? [103] NetLib being used by driver is DBNETLIB.DLL; Local host server is 2012-12-05 04:13:22 - ? [310] 8 processor(s) and 3326 MB RAM detected2012-12-05 04:13:22 - ? [339] Local computer is Myservername running Windows NT 5.2 (3790) Service Pack 22012-12-05 04:13:22 - ? [432] There are 12 subsystems in the subsystems cache2012-12-05 04:13:23 - ! [364] The Messenger service has not been started - NetSend notifications will not be sent2012-12-05 04:13:23 - ? [129] SQLSERVERAGENT starting under Windows NT service control2012-12-05 04:13:24 - + [396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect2012-12-05 04:13:24 - + [162] Internal request (from SetJobNextRunDate [reason: schedule will not run again]) to deactivate schedule 282012-12-05 04:13:24 - + [162] Internal request (from SetJobNextRunDate [reason: schedule will not run again]) to deactivate schedule 272012-12-05 04:13:24 - + [162] Internal request (from SetJobNextRunDate [reason: schedule will not run again]) to deactivate schedule 10--------------------------------------------------------------------------------Thu, 06 Dec 2012 09:38:25 GMTsqlfriendshttp://www.sqlservercentral.com/Forums/Topic1393145-1550-1.aspxdid you check SQL server agent logs ? check SQLAGENT.OUT files in your '\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log' directoryThu, 06 Dec 2012 00:28:27 GMTsanket kokanehttp://www.sqlservercentral.com/Forums/Topic1393145-1550-1.aspxRecently we have two SQL servers 2008R2 (SP1) experiencing a random restart of SQL agent. We are sure no one restarted but it restarted by its own and runs fine ever since.By looking at the error log in window event viewer:I see the error is:Event Type: ErrorEvent Source: .NET Runtime 2.0 Error ReportingEvent Category: NoneEvent ID: 1000Date: 12/5/2012Time: 4:13:03 AMUser: N/AComputer: MyServerNameDescription:Faulting application sqlagent.exe, version 2009.100.2500.0, stamp 4dfb13c1, faulting module kernel32.dll, version 5.2.3790.4480, stamp 49c51f0a, debug? 0, fault address 0x0000bef7.I cannot find any other clues, and not sure how to fix this, please help.ThanksWed, 05 Dec 2012 11:30:01 GMTsqlfriends