SQL server job Locks my table


  • Hello All,

    I am facing problem with sql server job,My job creates IP wise  dynamic cursor inside step 2, and problem is when all for e.g 5 IP in my table cursor created step 2 execution is done and step 3 is running, and when step 3 is running i am using same table used in step 2 and it throws error for locked table.

    I came to know that step 3 is executing but all 5 cursors is running one by one.

    Hope you are getting my issue.

    Please advice the solution ASAP.

    Thanks in advice.

    Freitag, 5. April 2013 09:07


  • Hi there,

    are you closing the cursor at the end of step2 ?

    Please make sure they are closed, that might solve your issue.



    • Als Antwort markiert Eileen Zhao Dienstag, 16. April 2013 06:34
    Montag, 8. April 2013 23:25