Some SQL scripts that modify database object raise an exception

Current Situation

• The _alter.sql SQL scripts are used to modify existing database objects, e.g. tables.
• The execution of the following scripts ends with an exception:
  • Microsoft SQL Server
    • $scheduler_home/db/mssql
      • reporting/daily_plan_alter.sql
        • The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION
      • reporting/inventory3_alter.sql (SQL Server versions before 2016)
        • Incorrect syntax near the keyword 'IF'
      • reporting/reporting_taskinsert_alter.sql
        • Invalid column name 'STEPS'
  • Oracle
    • $scheduler_home/db/oracle
      • inventory_alter.sql
        • Encountered the symbol "DECLARE"

Desired Behaviour

• The execution of the SQL scripts should work correctly without exceptions.