gerion

Удалить задачи

4 posts in this topic

Pinned posts

Подскажите как удалить задачи -список задач на скриншоте.

 

Отложить, возобновить, отмена в контекстном меню не активны.

Снимок.PNG

Share this post


Link to post
Share on other sites


UnPinned posts

В базе данных есть табица [Tasks], вней найти [TaskID] задачи "Convert to PDF" и "Сохранить в PDF".

Потом запустить запрос: delete [TaskInstances] where [TaskID] = TaskID из таблицы Tasks

 

Share this post


Link to post
Share on other sites

Спасибо.
печально что только через базу данных

Share this post


Link to post
Share on other sites

Сделайте бэкап БД и выполните следующий запрос:

-- Query to update all tasks of one type to another
-- Backup database before executing query.  
 
-- 1 [Waiting for host]
-- 2 [Starting up]
-- 3 [In process]
-- 4 [Retrying]
-- 5 [Suspended]
-- 6 [Cancelling]
-- 7 [OK]
-- 8 [Cancelled]
-- 9 [Failed]
-- 10 [Suspending]
-- 11 [Resuming]

-- Example: If there are tasks that are stuck in the "Cancelling", run the following query to correct it (i.e. update all tasks with status 6 [Cancelling] to status 8 [Cancelled]):


UPDATE TaskInstances
SET TaskStatus = 8   ---<< Update with new task status
WHERE TaskStatus = 6   ---<< Update with current task status
and TaskInstanceID > 1


 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.