Over the last couple of years, I have a lot of time to troubleshoot why scripts have failed.
Today I saw Cameron Fuller blog abut this issue. Below you can find a link to his blog.
Link: BlastFromThePast: Debugging the Script or Executable Failed to Run Alert