Serverless Tasks Flex¶

Create a flexible task¶

To create a flexible task, use the flexible scheduling mode and define the target completion interval to four hours or more. For more information about creating tasks, see CREATE TASK.

Syntax

CREATE [ OR REPLACE ] TASK [ IF NOT EXISTS ] <name>
  [ USER_TASK_MANAGED_INITIAL_WAREHOUSE_SIZE = <string> ]
  [ SCHEDULE = '{ <num> {MINUTES | MINUTE | M } | USING CRON <expr> <time_zone> }' ]
  [ SCHEDULING_MODE = 'FLEXIBLE']
  [ TARGET_COMPLETION_INTERVAL = '<num> {MINUTES | MINUTE | M }' ]
...

Copy

Parameters

SCHEDULING_MODE

Specifies the type of serverless task.

• FLEXIBLE uses a flexible task compute pool to complete the task. When creating a flexible task, you must also configure the TARGET_COMPLETION_INTERVAL parameter.

• FIXED uses the non-flexible serverless compute model for the task. If you don’t specify a scheduling mode, this creates a non-flexible task with the SCHEDULING_MODE set to NULL.

TARGET_COMPLETION_INTERVAL

Defines the amount of time that the task has to complete. The task starts after the scheduled time and attempts to complete within the target completion interval.

The target completion interval must be 60 minutes or more for flexible tasks.

Usage notes

• Flexible tasks must be serverless. This command returns an error if you specify a WAREHOUSE.

• Tasks will attempt to complete within TARGET_COMPLETION_INTERVAL, but aren’t guaranteed to complete within this time.

Examples

Creates a task that runs every six hours starting at the resume time, with a target completion of four hours.

CREATE TASK T1
  SCHEDULE='360 MIN'
  SCHEDULING_MODE = 'FLEXIBLE'
  TARGET_COMPLETION_INTERVAL='60 MINUTES'
  AS SELECT 1;

Copy

Creates a task that runs every day at midnight with a target completion time of four hours.

CREATE TASK T1
  SCHEDULE='USING CRON 0 0 * * *'
  SCHEDULING_MODE = 'FLEXIBLE'
  TARGET_COMPLETION_INTERVAL='60 MINUTES'
  AS SELECT 1;

Copy

Alter tasks¶

You can alter an existing task to convert it to a flexible task. Set the scheduling mode to flexible and define a target completion interval of greater than 60 minutes to convert your existing task to a flexible task.

To alter a task, suspend the task and then resume it after you finish modifications. For more information about altering tasks, see ALTER TASK.

Syntax

ALTER TASK [ IF EXISTS ] <name> SET
  [ SCHEDULING_MODE = 'FLEXIBLE' ]
  [ TARGET_COMPLETION_INTERVAL = '<num> {MINUTES | MINUTE | M }' ]

Copy

Parameters

SCHEDULING_MODE

Specifies the type of serverless task.

• FLEXIBLE uses a flexible task compute pool to complete the task. You must define the target completion interval to use FLEXIBLE.

• FIXED uses the non-flexible serverless compute model for the task.

TARGET_COMPLETION_INTERVAL

Defines the amount of time that the task has to complete. The task starts after the scheduled time and attempts to finish within the target completion interval.

The target completion interval must be more than four hours for flexible tasks.

Examples

Converts task t1 to a flexible task that runs every six hours starting at the resume time, with a target completion of four hours.

ALTER TASK t1 SET
  SCHEDULING_MODE = 'FLEXIBLE'
  TARGET_COMPLETION_INTERVAL = '60 MINUTES';

Copy

Converts task t1 to a flexible task that runs every day at midnight with a target completion time of four hours.

ALTER TASK t1 SET
  SCHEDULE='USING CRON 0 0 * * *'
  SCHEDULING_MODE = 'FLEXIBLE'
  TARGET_COMPLETION_INTERVAL = '60 MINUTES'

Copy