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