schwartzpub commented on issue #29037:
URL: https://github.com/apache/airflow/issues/29037#issuecomment-1397824977
Last run/next run aside -- what other details are needed that aren't
provided above? For reference, the documentation for 2.5 is where the
recommendation for `default_timezone = UTC` came from.
The dag definition is as follows:
```python
from datetime import datetime, timedelta
from airflow import DAG
from airflow.models import Variable
from airflow.operators.bash import BashOperator
import pendulum
with DAG(
"test_dataflow",
default_args = {
"depends_on_past": False,
"email": ["t...@test.com"],
"email_on_failure": False,
},
description="Test Dataflow",
schedule="*/15 6-17 * * 1-5",
start_date=pendulum.datetime(2023,1,19,6,tz='America/Chicago'),
catchup=False,
) as dag:
ssis_p = Variable.get("ssis_password")
bash_comm = "/opt/ssis/bin/dtexec /f
/home/airflow/airflow/ssis/Package.dtsx /de {0} /l
'DTS.LogProviderTextFile;ssis.txt'".format(ssis_p)
t1 = BashOperator(
task_id="ssis_dataflow",
bash_command=bash_comm
)
t1
```
The local server is set to CST
```
user@host:~$ sudo timedatectl
Local time: Thu 2023-01-19 06:44:37 CST
Universal time: Thu 2023-01-19 12:44:37 UTC
RTC time: Thu 2023-01-19 12:44:36
Time zone: America/Chicago (CST, -0600)
System clock synchronized: yes
NTP service: active
RTC in local TZ: no
```
The airflow.cfg is currently set to UTC but changing to `America/Chicago`
and restarting the schedulre and webserver services doesn't change the behavior:
```
default_timezone = utc
```
I cannot provide a screenshot since the run times in the UI are not a good
indicator (if there is a screenshot that can show this, I can certainly provide
one), but given the above configurations I would expect the first run each
weekday to happen at 6:15a CST. Instead, the first run of the day happens at
12:15pm CST. When I check the DAG in the morning(s) and through to the
afternoon there are no new runs until 12:15pm CST.
If there is any other information I can provide that might be missing here,
please let me know so I can provide it.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscr...@airflow.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
