In the My Executions area of G Suite Developer Hub I can see that there is an automated Time Driven task that runs once per hour for Files Cabinet.
From what I can tell, this script attempts a full read of the google drive (an automated update).
However this job sometimes runs for just under a second and completes, I note that there are no updates or changes to the excel sheet so I will assume that in these cases File Cabinet reckognizes that there have not been any new files added to the library and does not attempt to make an update to the excel sheet.
However if files have been added, this job triggers and runs for about 10 minutes, again, I assume it is attempting to do a full update to the excel sheet. Now in my case the library is fairly good sized (around 2700 files and about 1500 folders and sub-folders). This update either doesn't capture any files other than those on the root directory or does a partial update.
My question is two fold.
1. Is it possible to change the Time when this job runs or otherwise control its schedule (consequently even removing it and leaving updates to be done manually)?
2. Secondly, when it does the automated update after files have been added, it registers as "complete", but it clearly did not do a complete update so its giving me a false positive. Any suggestions on how I might remedy this?
Please sign in to leave a comment.