It is not possible if the tasks are scheduled individually i.e., tasks will run individually as per their schedule on the warehouse.

You could create the task dependency using task graphs.

A task graph is a series of tasks composed of a root task and child tasks, organized by their dependencies. Each task can depend on multiple other tasks and won’t run until they all complete.

Please review the below documentation for more information:

https://docs.snowflake.com/en/user-guide/tasks-graphs