[SharePoint 2013] How to remove SPWorkItem in database

Question

Hello,

I would like to remove all SPWorkitem already created.

Here is my sql request to see them:

select * from [WSS_Content].[dbo].[ScheduledWorkItems]

I tried different things (in same time):

using (SPSite site = new SPSite("http://srv-sp2k13ad"))
            {

                SPWorkItemCollection items = new SPWorkItemCollection(site, new Guid("{257A8273-7324-40E8-81D3-45355F0EBD81}"));

                uint rows, columns;
                object workerItemsObject;
                items.GetType().GetProperty("GetAllWorkItems", BindingFlags.NonPublic | BindingFlags.Instance).GetSetMethod(true).Invoke(items, new object[] { true });
                site.GetWorkItems(items, out columns, out rows, out workerItemsObject);

//First try
                items.DeleteInProgressWorkItems(Guid.Empty, new Guid("{257A8273-7324-40E8-81D3-45355F0EBD81}"), Guid.Empty);
//second try
                items.RevertInProgressWorkItems(Guid.Empty, Guid.Empty, new Guid("{257A8273-7324-40E8-81D3-45355F0EBD81}"), Guid.Empty, true);
                foreach (SPWorkItem i in items)
                {
//Third try
                    items.DeleteWorkItem(i.Id);
                }
            }

They still in my database. Any Idea?

Regards,

Julien Dufour

Answer 1

Bonjour,

Vous pouvez trouver ici : Processing items with Work Item Timer Jobs in SharePoint 2010 un exemple pour SharePoint 2010 :

// Delete(): required to remove the item from the queue
workItems.SubCollection(site, web, 0, (uint)workItems.Count).DeleteWorkItem(workItem.Id);

A voir si celà s'applique pour le 2013.

---

My technical blog on SharePoint || My contributions on the TechNet Gallery

Answer 2

Bonjour,

Votre solution s'applique uniquement dans le cas où l'on se trouve dans la méthode processItem(s) d'un SPWorkItemJobDefinition, hors je souhaiterais pouvoir le faire à partir de n'importe quel contexte.

Answer 3

I'm not finding any workaround for this case, and still need this.

Any hint?

Thanks in advance.

Answer 4

$siteUrl = "TARGET_SITE_COLLETION_URL"
$site = [Microsoft.SharePoint.SPSite](Get-SPSite $siteUrl)
$workItemId = [Guid]"WORK_ITEM_GUID";
$workitems =  New-Object Microsoft.SharePoint.SPWorkItemCollection($site, $workItemId);
$workitems.DeleteWorkItem($workItemId)