Post reply

Job in Rollback not showing in Activity Monitor

  • February 22, 2015 at 9:27 pm

    #398054

    Hi Experts,

    We have killed a job which is now in KILLED\ROLL BACK state. Job activity monitor is not showing any running jobs but I can see the SPID of that job. When tried to kill again its giving the message ‘command completed successfully‘, not able to get the percentage or time for the roll back to complete.

    Please help in identifying more details about this process. Another DBA tried to create a snapshot and it was stuck and I believe it was because of this ROLLBACK as both were using same Database.

    TIA

  • February 22, 2015 at 10:41 pm

    #1779177

    Which kind of the job it is. It is User created or created by system, such as in case of replication, SQL Server creates certain jobs?

  • February 23, 2015 at 8:18 am

    #1779272

    What type of query executed via the job .

    what is the Wait type in the SPID . Do you observe any blocking , do you see I/O changes .

  • February 23, 2015 at 5:37 pm

    #1779454

    Thanks for the reply.

    Its a user created job is to update and delete some values from a table. Wait type was showing IO_COMPLETE

  • February 23, 2015 at 11:18 pm

    #1779484

    Doe the job use xp_CmdShell or a CmdExec step?

    --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)

  • February 24, 2015 at 5:32 pm

    #1779780

    Jeff Moden (2/23/2015)

    Doe the job use xp_CmdShell or a CmdExec step?

    Nope...

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

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