Feat: Ability to enable / disable a task

[robe2]

While I was building a pgAdmin UI for pg_timetable - here - pgadmin-org/pgadmin4#10152
I noticed it doesn't seem to have ability to disable tasks. Disabling individual tasks in a job was something I used often in pgAgent. Is there a reason for this or am I just missing something?

[pashagolub]

Hey Regina.

Thanks for your work. Well, we never thought we want to disable some tasks. But sounds doable. Do you have any use case on mind?

[robe2]

Hey Regina.

Thanks for your work. Well, we never thought we want to disable some tasks. But sounds doable. Do you have any use case on mind?

Yes like for example if I have a long running task in a chain and I need to test the other tasks, I might temporarily disable that task while I'm testing other tasks in the chain. I don't want to have to reinput the task, I want to just reenable it once I am done with my testing.

There is another common case I have, in a chain, I normally refresh a materialized view first and then clear a website cache. But on occasion, since the materialized view takes so long to build and I know I made a UI change that impacts this, I may want to just clear the cache for a particular run without having to rebuild the view.

[pashagolub]

Can you give a quick try to #794?

[robe2]

Can you give a quick try to #794?

Looks good, it upgraded my db:

2026-07-16 02:44:06.487 [INFO] Applying migration named '00792 Add ability to enable and disable tasks'...
2026-07-16 02:44:06.489 [INFO] Applied migration named '00792 Add ability to enable and disable tasks'

Before disabling task: test task

2026-07-16 02:49:06.495 [INFO] [chain:18|Test 3] [task:43|test task] [vxid:180388628286] Starting task
2026-07-16 02:49:06.496 [INFO] [chain:18|Test 3] [task:43|test task] [vxid:180388628286] Task executed successfully
2026-07-16 02:49:06.497 [INFO] [chain:18|Test 3] [task:46|test sleep 2] [vxid:180388628286] Starting task
2026-07-16 02:49:08.514 [INFO] [chain:18|Test 3] [task:46|test sleep 2] [vxid:180388628286] Task executed successfully

After disabling

2026-07-16 02:54:06.493 [INFO] [chain:18|Test 3] Starting chain
2026-07-16 02:54:06.494 [INFO] [chain:18|Test 3] [task:46|test sleep 2] [vxid:124554053514] Starting task
2026-07-16 02:54:08.504 [INFO] [chain:18|Test 3] [task:46|test sleep 2] [vxid:124554053514] Task executed successfully
2026-07-16 02:54:08.504 [INFO] [chain:18|Test 3] [vxid:124554053514] Chain executed successfully

After renabling

2026-07-16 03:02:06.495 [INFO] [chain:18|Test 3] [task:46|test sleep 2] [vxid:188978563833] Starting task
2026-07-16 03:02:08.510 [INFO] [chain:18|Test 3] [task:46|test sleep 2] [vxid:188978563833] Task executed successfully
2026-07-16 03:02:08.510 [INFO] [chain:18|Test 3] [task:43|test task] [vxid:188978563833] Starting task
2026-07-16 03:02:08.512 [INFO] [chain:18|Test 3] [task:43|test task] [vxid:188978563833] Task executed successfully
2026-07-16 03:02:08.512 [INFO] [chain:18|Test 3] [vxid:188978563833] Chain executed successfully

The shuffling of order was my fault I assigned the same task order to both.