Snowflake network monitors every automation created. As soon as the triggered condition is met, the network will execute the automation on your behalf.
In the example below, the automation will be executed as soon as the count down reaches zero.
Post execution, the transaction detail will be logged under Execution History. For recurring automation, Snowflake will automatically reschedule the automation to the next time interval.
If you are interested in technical architectures, checkout out the Snowflake Node Operator consensus model.