Post reply

purge data job in suspended state

  • May 16, 2012 at 1:25 am

    #256518

    Hi Everyone,

    Hope all is well.

    I have scheduled a sql agent job to delete data older than 180 days from a couple of tables. I see the difference in the number of records in the two tables but the job wont complete. I did an sp_who2 and I see that the job is in suspended state. What I am trying to do is delete data from a couple of tables which is older than 35 days and since the tables are huge I am running the job in batches. But its been more than an hour and I can see the difference in the number of records in the two tables but the job wont complete.

    ANy ideas?

    Thanks for ur help.

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

  • May 16, 2012 at 7:54 am

    #1488412

    You could try a trace to see how long its taking to complete one batch. With that and the total number of records you expect to be deleted, you can estimate the time it will take to complete.

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

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