Post reply

How to find SQL job are in progress.

  • December 13, 2013 at 11:49 am

    #301379

    I can see SQL server job are running from one day and still not completed. Please let me know how to find my this running jobs are in progress or they are struck\hung.:-)

  • December 13, 2013 at 6:32 pm

    #1673439

    This can be a lengthy process. The first step that I'd take would be to see if there's any blocking in the database by running sp_Who2.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • December 14, 2013 at 10:05 am

    #1673473

    ... ++ how long it take normaly ?, check from the histoy.

    What actualy the job is doing ? how much % is completed is available in sys.dm_exec_request ?

    ..As already specified above, I too suspect blocking. Check for blocking as suggested and see if you can get rid of the lead blocker.

Viewing 3 posts - 1 through 3 (of 3 total)

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