Abort all Queued Tasks

Stop the Ouvvi processing service and issue the following SQL to the Ouvvi DB.

Sometimes after a server reboot or if you have queued to many tasks you might want to abort and clear everything. Stop the Ouvvi processing service and issue the following SQL to the Ouvvi DB. This will set each queued project to Abort Status and unlock any Steps on the Queue when you re-start the service.

INSERT INTO [dbo].[ProjectAbort] (InstanceID, Expires) SELECT DISTINCT InstanceID, DATEADD(d, 1, GETUTCDATE()) FROM [dbo].[Queue]
GO
UPDATE [dbo].[Queue] SET Status = 0


Can't find the answers you're looking for? Contact our support team and we'll personally get back to you as quickly as we can.