Do not change time for running scheduled queries due to summer time [152711968]

Assigned

Feature Request

Status Update

No update yet.

Description

ma...@fundayfactory.com

created issue #1

Mar 30, 2020 06:14AM

Please provide as much information as possible. At least, this should include a description of your issue and steps to reproduce the problem. If possible please provide a summary of what steps or workarounds you have already tried, and any docs or articles you found (un)helpful.

Problem you have encountered:
All my scheduled queries now run 1 hour later, because time has been changed to summer time (+1 hour) in my timezone. I've set the time after France, but apparently it is only calculated from UTC timezone. That's very unhelpful, because that means that I have to change all my queries every 6 months.

What you expected to happen:
If I choose the timezone France, then it should always run the queries according to the time I set in this timezone. E.g., 7:30 AM should always be 7:30 AM in my chosen timezone.

Steps to reproduce:
1. Set scheduled query to run at 7:30 AM France timezone (UTC +1).
2. France changes to summer time (UTC +2).
3. Query now runs at 8:30 AM France timezone (UTC +2).

Other information (workarounds you have tried, documentation consulted, etc):

Comments

bl...@google.com <bl...@google.com> Mar 30, 2020 06:14AM

Assigned to gi...@google.com.

gi...@google.com <gi...@google.com> Mar 30, 2020 05:29PM

Reassigned to sh...@google.com.

ta...@swc.co.il <ta...@swc.co.il> #2Mar 31, 2020 01:08PM

fa...@windtre.it <fa...@windtre.it> #3Apr 3, 2020 05:37PM

sh...@google.com <sh...@google.com> Aug 6, 2020 10:20PM

Reassigned to bw...@google.com.

bw...@google.com <bw...@google.com> #4Aug 7, 2020 12:53AM

Thanks for the feedback. We will consider for our roadmap.

bw...@google.com <bw...@google.com> Sep 3, 2020 11:50PM

Reassigned to mi...@google.com.

[Deleted User] <[Deleted User]> #5Nov 3, 2020 03:22PM

We are still having the exact same issue.

The scheduled query was an hour's late after the winter time started and we will have to modify our time-sensitive queries twice a year... Please fix this issue. We are hoping the scheduled query time will be changed automatically as summer time starts/ends.

Thanks!

Message last modified on Nov 3, 2020 03:31PM

rn...@gmail.com <rn...@gmail.com> #6Dec 2, 2020 12:32AM

I wish we could just schedule in UTC....this time zone selection has ruined scheduled jobs in BQ UI

[Deleted User] <[Deleted User]> #7Mar 30, 2021 08:25AM

I have had the same issue with a query running 1 hour later than expected after the recent change to BST (UTC+1).

iv...@autoscout24.com <iv...@autoscout24.com> #8Apr 23, 2021 12:25PM

We have the same issue - schedules just run 1 hr later on CET time and the change in the BQ UI is not able to overwrite it. This is frustrating. Thanks!

jo...@meermetdata.nl <jo...@meermetdata.nl> #9Nov 4, 2021 11:33PM

Same issue here, scheduled time stays CEST instead of CET. So refresh is an hour early.

di...@gmail.com <di...@gmail.com> #10Jul 12, 2022 04:21PM

I'm still having this problem. Is there any workaround?

ra...@kinesso.com <ra...@kinesso.com> #11Dec 5, 2022 10:05AM

Still having the same issue. Is there any news about it?

ma...@emap.com <ma...@emap.com> #12Apr 5, 2023 02:09PM

Hello,

Is there an update to this ticket or a work around for this issue.

Thanks

ta...@gmail.com <ta...@gmail.com> #13Oct 31, 2024 03:20PM

Any update on this issue, everytime day light savings change, have to updated the scheduled queries. this is frustrating.

mi...@brightspeed.com <mi...@brightspeed.com> #14Dec 17, 2024 01:48PM

Is there any update on this? We are in production with many scheduled queries and this is a huge pain and causes production issues. This bug has been sitting here for years I cannot believe this has not been fixed yet. I have never heard of any job scheduler changing the timing of your jobs

ce...@google.com <ce...@google.com> #15Feb 27, 2025 04:39PM

Is there any update on this? Our customer has the same question about Data Fusion.