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
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.
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