Edit SD.Next task que using sqlite3

Sometimes it is not possible to remove hanged task from SD.Next - it is instantly re-scheduled.

that is can be done by direct edit of sqlite3 database like shown below

# apt install sqlite3
sqlite3 /docker/sdnext/app-volume/extensions-builtin/sd-webui-agent-scheduler/task_scheduler.sqlite3

sqlite> .tables
app_state  task

sqlite> .schema task
CREATE TABLE task (
        id VARCHAR(64) NOT NULL,
        api_task_id VARCHAR(64),
        api_task_callback VARCHAR(255),
        name VARCHAR(255),
        type VARCHAR(20) NOT NULL,
        params TEXT NOT NULL,
        script_params BLOB NOT NULL,
        priority INTEGER NOT NULL,
        status VARCHAR(20) NOT NULL,
        result TEXT,
        bookmarked BOOLEAN,
        created_at DATETIME DEFAULT (datetime('now')) NOT NULL,
        updated_at DATETIME DEFAULT (datetime('now')) NOT NULL,
        PRIMARY KEY (id)
);


sqlite> .schema task
CREATE TABLE task (
        id VARCHAR(64) NOT NULL,
        api_task_id VARCHAR(64),
        api_task_callback VARCHAR(255),
        name VARCHAR(255),
        type VARCHAR(20) NOT NULL,
        params TEXT NOT NULL,
        script_params BLOB NOT NULL,
        priority INTEGER NOT NULL,
        status VARCHAR(20) NOT NULL,
        result TEXT,
        bookmarked BOOLEAN,
        created_at DATETIME DEFAULT (datetime('now')) NOT NULL,
        updated_at DATETIME DEFAULT (datetime('now')) NOT NULL,
        PRIMARY KEY (id)
);
sqlite> SELECT id, name, status  FROM task;
task(fhraih0ryzwm1iq)||done
task(93jw8bgegiaczkr)||pending
220fd698-05db-4224-8480-03ced279d906||pending
sqlite> DELETE FROM task WHERE id = '220fd698-05db-4224-8480-03ced279d906';

sqlite> .exit