question

56220211 avatar image
0 Votes"
56220211 asked ShaikMaheer-MSFT commented

Synapse trigger time zone

I have a scheduled trigger in Synapse to start at 12:05 am EST daily. However, the trigger actually starts at 7:05 pm previous day. What's wrong in this trigger? It used to work before, but recently this trigger was updated via Azure CLI (az synapse trigger set), but not sure if it is anything to do with this .

177985-image.png



azure-synapse-analytics
image.png (29.5 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

ShaikMaheer-MSFT avatar image
0 Votes"
ShaikMaheer-MSFT answered ShaikMaheer-MSFT commented

Hi @56220211 ,

Thank you for posting query in Microsoft Q&A Platform.

As I understand query here, you are looking difference between pipeline trigger schedule time and pipeline actual trigger execution time. Kindly feel free to correct if I am wrong.

I tried to repro scenario using schedule trigger, I don't see any issues as you mentioned. Please check below details and screenshots.
178858-image.png

One possible reason behind you are seeing difference may be is, You might be seeing trigger by connecting workspace to repo. Could you please switch your workspace to live mode and see same trigger inside management hub?
178882-image.png

Hope this helps. Please let us know how it goes.


Please consider hitting Accept Answer. Accepted answers helps community as well.



image.png (240.8 KiB)
image.png (64.6 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks for your response. I am sure I checked the trigger in the live mode. It is very strange but I started seeing this issue only after updating the trigger in the Live mode through Azure CLI. To recreate the issue, can you please try updating the trigger with CLI (maybe change the time) and then notice the trigger execution time? Please let me know if you need more details.

0 Votes 0 ·

Hi @ 56220211 ,

I guess Triggers start time cannot be updates once you created and published them. Consider creating new trigger and deleting old trigger to avoid this.


Please consider hitting Accept Answer. Accepted answers helps community as well.

1 Vote 1 ·