Avoid storing general scripts in private folders; they may become outdated and cause issues. Instead, use private GIT repositories for better maintenance, backup, and version control.

Creator/Owner must delete temp tables as required (within approximately 2 weeks ) after script execution is completed, in case clean up jobs are not available. This helps ensure that jobs do not fail in the production database because of space issues.

It is  good practice to log your work so you can refer to it later.  Such logs prove extremely useful in resolving issues and for monitoring and validating the results.