Post reply

SQL job is getting hanged

  • February 5, 2014 at 1:57 am

    #303772

    We have sql2005 standered edition and now a days one sql job is getting hanged frequently.

    But if i stop and then start it runs fine. How to trouble shoot this issue?

  • February 5, 2014 at 2:03 am

    #1686113

    What exactly do you mean by 'hanged'? What is happening? What are the exact error messages you're getting (if any)?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • February 5, 2014 at 2:46 am

    #1686117

    This job runs for a long time (more than 3 hrs) but normally it takes few seconds to complete.

    Now if i stop and start the job it takes only few seconds to complete.

    Please suggest how to troubleshoot this issue.

  • February 5, 2014 at 3:22 am

    #1686121

    Maybe a server-side trace to identify what's happening.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • February 5, 2014 at 4:06 am

    #1686137

    Alone (2/5/2014)

    We have sql2005 standered edition and now a days one sql job is getting hanged frequently.

    Have you tried:

    sp_configure 'disable capital punishment', 1?

    😀

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

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