Post reply

Sql Service Agent Timeout

  • January 19, 2010 at 1:42 pm

    #229261

    Does anyone know why when trying to view job history, it keeps timing out? If so, how did/do you go about troubleshooting the problem.

  • January 19, 2010 at 2:04 pm

    #1105736

    It could be because you are keeping the history of Jobs for a very long time. You can limit this by changing the values in the properties of SQL Server Agent.

    -Roy

  • January 19, 2010 at 2:13 pm

    #1105739

    Thanks for your response, I changed the values and purged the history and there are still some timeouts. Any other reason? Beats me. Thanks again!

  • January 19, 2010 at 2:18 pm

    #1105741

    When you are trying to retrieve the history, try to find out what is happening. Try sp_who2. Also try to get the history using T-SQl by joining sysjobhistory and sysjobs in msdb

    -Roy

  • January 19, 2010 at 2:37 pm

    #1105744

    Thanks for your help. It is appreciated !

  • January 20, 2010 at 9:07 am

    #1106116

    Might not be related, but in the past when I've had timeouts in viewing job history it's been as a result of an Async_Network_IO wait type.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply