Configuration Management Transfer Status

Question

I'm running Configuration Manager 7.1.1 with no service packs. When I go to my Configuration Management page I have, under Transfer Status, some jobs that are hung up. I can't clear them and I can't clear any other jobs either, I think tha's because some of the jobs are hung. I've checked and I think that there is traffic associated with these jobs so I'd like to clear them out but can't seem to find where to do that. If anyone has a thought that would be a great help to me. Thanks

branfarm · Accepted Answer

Someone with more SQL experience can probably provide a better answer, but I had this same issue and I went into SQL management studio and did the following:

1. Start a new query on the ConfigMgmt database.

SELECT * FROM TransferQueue

2. Locate the lines you want to delete and pick a column to use to identify them.  I wanted to clear out everything, so I did:

DELETE FROM TransferQueue WHERE Status = 'Complete'

That cleared out all of my 'stuck' entries.