[HELP] Scheduled Run Timeout vs Manual Run < 5 Minutes

[Brad FISHER]

Hi everyone,

New user here but a long-time app script code writer. 

Recently, I've noticed a number of my scripts involving fetching JSON API XML sources were timing out at 30 minutes that were scheduled during the day at specific times.

The odd part is that when I manually run numerous of my app scripts, the same scripts are finished in under 5 minutes.

I had purposely put in Logger commands to review the logs and noticed the speed of simple loops to grab the JSON XML data had drastically slowed down where items were taking 30-45 seconds per loop on a scheduled app script. Yet, if I ran the same loop manually, it was being done in under a second.

These app scripts and google sheets are stored in shared drives (not sure if that would impact it).

Has anyone encountered this before or have any general advise? 

[David Chapuis]

Hi,

Could you solve the issue?

I am currently runing into a kind of similar issue and don't know what is happening.

My post here https://groups.google.com/g/google-apps-script-community/c/mWZdhcWwXs4

[Andrew Roberts]

Sometimes just the time of day can affect how long a script takes to run. I find things slow down one the US comes online.

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/78dcb117-4bcd-46a5-ba4d-e65cadc83127n%40googlegroups.com.

[DimuDesigns]

@AndrewRoberts Is that only for consumer accounts or does this also apply to paid Google Workspace accounts?

[David Chapuis]

In my case, it was a mistake of mine, I had an infinite while loop in my code :D :/

[Andrew Roberts]

@Dimu Designs I've not monitored whether I'd been on a WorkSpace account or not - but there have been a few evenings (GMT) when I've just given up work as the script was taking so long to run, especially in the debugger.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/75fdd7f9-cdd0-44f3-b326-2f5cf0625559n%40googlegroups.com.