Hi,
I'm going to suggest you just one thing that you can include in your procedure for maintenance and execution of scripts: Create a copy of the DB/Server in a temp space and execute all scripts that you're planning to include during the maintenance.
Benefits:
- You can tell if it's going to work as expected
- You can estimate the time required to do the same in production