I have an Airflow dag that I need to schedule at the same time whether it is standard or daylight savings time, but the airflow server and cron scheduling is based on utc. It needs to run after a database restore occurs and that server runs the restore based on the local time.
This is causing me to have to schedule it an hour later during daylight savings time. Is there a way to have airflow run the job at the same hour whether it is daylight savings time or standard time?
For example, the database restore completes at noon and 8PM daily. This time is the same whether it is PDT or PST. Any way to do this in cron so that the time the job runs is always at noon and 8pm?