Can we trigger snowflake task manually or enable to run at a specific day and time

When using USING CRON the following format is accepted:

# __________ minute (0-59)
# | ________ hour (0-23)
# | | ______ day of month (1-31, or L)
# | | | ____ month (1-12, JAN-DEC)
# | | | | _ day of week (0-6, SUN-SAT, or L)
# | | | | |
# | | | | |
  * * * * *

There is no year option, so something like this would work:

'USING CRON 0 9-17 * * SUN America/Los_Angeles'

• every hour starting at 9 AM and ending at 5 PM on Sundays (America/Los_Angeles time zone)

Yes, it is possible to run task manually using EXECUTE TASK

Manually triggers an asynchronous single run of a scheduled task (either a standalone task or the root task in a task tree) independent of the schedule defined for the task.

A successful run of a root task triggers a cascading run of child tasks in the tree as their precedent task completes, as though the root task had run on its defined schedule.

EXECUTE TASK <task_name>;