Wednesday, September 3, 2014

Index queue status " Awaiting indexing "

You can delete items from the index queue either through DA or using DQL so if you wanted to delete all index queue items for dm_job objects you would use DQL like

delete dmi_queue_item objects where name = 'dm_fulltext_index_user' and item_type = 'dm_job'


Run a select with the same criteria first just to make sure that only those queue items you want to delete are being selected though.

If you want to permanently stop dm_job objects being indexed then you'll have to unregister dm_sysobject and register only those types you are interested in. There is info on this in the following threads.

No comments:

Post a Comment