SQL Statement to add documents back to the Distributed Queue : PIF Technologies

SQL Statement to add documents back to the Distributed Queue Print

Modified on: Thu, 3 Nov, 2022 at 7:38 AM

INSERT INTO [dbo].[DistributedQueue] ([Id],[DistributedTaskFlag],[SortDate],[Arguments],[Priority],[ClientRequirements],[RequiredDistributedTaskFlag],[RequiredArguments],[FailureCount],[NotificationLevel],[Title])

SELECT DISTINCT TOP 500000 NEWID(),1,GETDATE(),dv.Id,5,0,NULL,NULL, 0, 2, dv.Title

FROM DocumentVersionContent dvc

INNER JOIN dbo.DocumentVersion dv ON dvc.DocumentVersionId = dv.Id

INNER JOIN Document d ON dv.DocumentId = d.Id

WHERE ContentItemId IN(SELECT Id FROM ContentItem WHERE (ImageState != 1)) AND d.Deleted = 0

Did you find it helpful? Yes No

SQL Statement to add documents back to the Distributed Queue Print

Related Articles