Tasks: Alter singleton tasks without suspending them first (Pending)¶

This behavior change lets you run ALTER TASK on a resumed singleton task without first suspending it. A singleton task is a standalone task that has no predecessor, no successor, and no finalizer (that is, it is not part of a task graph). The updated task properties take effect on subsequent scheduled executions of the task.

This change applies only to singleton tasks. Altering a task that is part of a task graph (a task with a predecessor, successor, or finalizer) continues to require the task to be suspended first.

Before the change:

Running ALTER TASK on a resumed singleton task returns an error. To modify the task, you must first suspend it, alter it, and then resume it:

Copy code

-- Fails while the task is resumed
ALTER TASK my_task SET SCHEDULE = '10 MINUTES';

-- Supported workaround
ALTER TASK my_task SUSPEND;
ALTER TASK my_task SET SCHEDULE = '10 MINUTES';
ALTER TASK my_task RESUME;

After the change:

Running ALTER TASK on a resumed singleton task succeeds without suspending the task. The updated properties take effect on subsequent scheduled executions of the task:

Copy code

-- Succeeds without suspending the task
ALTER TASK my_task SET SCHEDULE = '10 MINUTES';

Ref: 2363