# Transaction groups schedule execution time

**URL:** <https://forum.inductiveautomation.com/t/transaction-groups-schedule-execution-time/111685>\
**Category:** Ignition\
**Tags:** troubleshooting\
**Created:** [October 23, 2025, 7:16pm UTC](https://forum.inductiveautomation.com/t/transaction-groups-schedule-execution-time/111685 "2025-10-23T19:16:13Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![oscar.ruiz](https://avatars.discourse-cdn.com/v4/letter/o/b9bd4f/32.png) [@oscar.ruiz](https://forum.inductiveautomation.com/u/oscar.ruiz)\
**Post date:** [October 23, 2025, 7:16pm UTC](https://forum.inductiveautomation.com/t/transaction-groups-schedule-execution-time/111685/1 "2025-10-23T19:16:14Z")

</div>

I have several transaction groups storing data at shift’s end every day. It has been working without issues, but in the last days, the group executes one hour before the scheduled time. Is there someplace where the SQL Bridge time may have changed?

All the scheduled scripts work on the right time, only the transaction groups have this offset.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/1/f1c3f9de0bb178da7d4772da21cccce323187cbe.png)

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/e/fe006b4f0cfcdce41051018595178661b3e4eebd.png)

---

<div class="post-metadata">

**Author:** ![dkhayes117](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dkhayes117/32/68344_2.png) [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\
**Post date:** [October 23, 2025, 7:25pm UTC](https://forum.inductiveautomation.com/t/transaction-groups-schedule-execution-time/111685/2 "2025-10-23T19:25:01Z")

</div>

Maybe a datetime setting or time zone difference between the Ignition server and your DB server?

Whatever it is, I usually have a shift active tag (boolean) and use that tag to trigger instead of a schedule. If the schedule ever changes, modify the shift active expression or script and all your transaction groups will follow without need to reconfigure each one.

---

<div class="post-metadata">

**Author:** ![oscar.ruiz](https://avatars.discourse-cdn.com/v4/letter/o/b9bd4f/32.png) [@oscar.ruiz](https://forum.inductiveautomation.com/u/oscar.ruiz)\
**Post date:** [October 23, 2025, 9:00pm UTC](https://forum.inductiveautomation.com/t/transaction-groups-schedule-execution-time/111685/3 "2025-10-23T21:00:15Z")

</div>

Thanks, I thought about timezone, but both servers have the same one. I guess the triggered execution will be the best solution, but I can understand what’s happening, that would be great. Also, I’d rather not go through all these transaction groups changing them to triggered.

---

<div class="post-metadata">

**Author:** ![dkhayes117](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dkhayes117/32/68344_2.png) [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\
**Post date:** [October 24, 2025, 12:08pm UTC](https://forum.inductiveautomation.com/t/transaction-groups-schedule-execution-time/111685/4 "2025-10-24T12:08:46Z")

</div>

Check the current time on your gateway and run `select now()` in a query to see if they match. You said you checked TZ settings but did not say whether the current time matched.

---

<div class="post-metadata">

**Author:** ![oscar.ruiz](https://avatars.discourse-cdn.com/v4/letter/o/b9bd4f/32.png) [@oscar.ruiz](https://forum.inductiveautomation.com/u/oscar.ruiz)\
**Post date:** [October 24, 2025, 2:27pm UTC](https://forum.inductiveautomation.com/t/transaction-groups-schedule-execution-time/111685/5 "2025-10-24T14:27:59Z")

</div>

the current time matches to the second, I’ve checked with queries and scripts. The timestamp on database gives the right time; just these transaction groups are off.

I have other transaction groups on the same table executing every minute, and they get the scheduled time right.

Thank you

---

<div class="post-metadata">

**Author:** ![dkhayes117](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dkhayes117/32/68344_2.png) [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\
**Post date:** [October 24, 2025, 2:34pm UTC](https://forum.inductiveautomation.com/t/transaction-groups-schedule-execution-time/111685/6 "2025-10-24T14:34:37Z")

</div>

I’m not sure then, maybe someone else will chime in.