[Feature]: task seconds and hours scheduling #3638
Description
Company Name
paynetworx llc
Use Cases or Problem Statement
support second and hour schedule configuration on tasks
'num { HOURS | MINUTES | SECONDS }'
Specifies an interval of wait time between runs of the task.
Snowflake sets the base interval time when the task is resumed (ALTER TASK … RESUME) or when a different interval is set (ALTER TASK … SET SCHEDULE).
For example, if an INTERVAL value of 10 MINUTES is set and the task is enabled at 9:03 AM, then the task runs at 9:13 AM, 9:23 AM, and so on.
Snowflake ensures that a task won’t run before the set interval; however, Snowflake can’t guarantee task runs at precisely the specified interval.
Values: { 10 - 691200 } SECONDS, { 1 - 11520 } MINUTES, or { 1-192 } HOURS (That is, from 10 seconds to the equivalent of 8 days). Accepts positive integers only.
Also supports the notations: HOUR, MINUTE, SECOND, and H, M, S.
from https://docs.snowflake.com/en/sql-reference/sql/create-task
Category
category:resource
Object type(s)
resource:task
Proposal
allow seconds and hours specifications
How much impact is this issue causing?
Medium
Additional Information
No response
Would you like to implement a fix?
- Yeah, I'll take it 😎