is

osquery_schedule

only useful during an execution?

Correct, this table is only populated with runtime information. If osqueryd stops the information is not saved.

got it, thanks!