How To

Abort All Queued Tasks

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