Unfortunately, there's no way to create a scheduled task that just wakes the computer up.
The only non-deprecated action a scheduled task can perform is running a program/script.
However, like in many cases, there's a workaround. You can configure a scheduled task to wake the computer up to perform the task. If the action is, for example, "open a cmd an immediately close it", a scheduled task can wake the computer up at a specific time.
It sounds as if you already know how to create a scheduled task, so I'll just skip to the interesting parts.
After configuring what time and how frequently you want the task to run, the action you want to add is "start a program". Under "Program/script", write "/c exit". This is a simple command that will end cmd/powershell sessions.
Open the scheduled task's properties. In the "general" tab, mark "Run whether user is logged on or not", for obvious reasons.
Now all that's left is to make the scheduled task wake the computer up if need be. In the properties, and under "conditions" mark "wake the computer to run this task". You might also want to remove the mark on "Start the task only if the computer is on AC power", if you're using a laptop. There's no need to give the task any special privileges.
And there you go - a new scheduled task that wakes the computer up whenever you want.