sidnalla opened a new issue, #31618: URL: https://github.com/apache/airflow/issues/31618
### Apache Airflow version Other Airflow 2 version (please specify below) ### What happened Airflow Scheduler not working as expected with SQL Server as backend whereas the same configuration working fine with Postgres as backend. The DAGs are not getting triggered as per the schedule. And also the manual trigger is not working as expected. In case of manual trigger, the DAGs are getting started after 4 hours of the manual trigger time. If the DAGs are manually triggered at 9 AM UTC, they are running at 1 PM UTC(4 hours after the trigger time). Looks like it is considering the EST time(server time where Airflow is running). We have changed the below parameters to match the timezones for the Server on which Airflow is running and the UI timezone. We set the below two parameters to America/NewYork since the server is in EST zone. But, we are still seeing the same issue. The same configuration works fine when we use Postgres as the backend. AIRFLOW__CORE__DEFAULT_TIMEZONE AIRFLOW__WEBSERVER__DEFAULT_UI_TIMEZONE Could you please clarify if something needs to be changed when we use Sql Server as the backend? ### What you think should happen instead _No response_ ### How to reproduce If the DAGs are manually triggered at 9 AM UTC, they are running at 1 PM UTC(4 hours after the trigger time). Looks like it is considering the EST time(server time where Airflow is running). We have changed the below parameters to match the timezones for the Server on which Airflow is running and the UI timezone. We set the below two parameters to America/NewYork since the server is in EST zone. But, we are still seeing the same issue. The same configuration works fine when we use Postgres as the backend. AIRFLOW__CORE__DEFAULT_TIMEZONE AIRFLOW__WEBSERVER__DEFAULT_UI_TIMEZONE ### Operating System linux ### Versions of Apache Airflow Providers _No response_ ### Deployment Virtualenv installation ### Deployment details _No response_ ### Anything else _No response_ ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://github.com/apache/airflow/blob/main/CODE_OF_CONDUCT.md) -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
