Automation Script hangs and Windows Scheduler task does not complete. (4219927)

Automation script contains a SQL Server script that updates tables with embedded commits. This automation task runs successfully in Toad. When scheduled, task appears to be executed as table updates are perfomed but Windows continues to show task as "Running" and eventually times out.

Once task is completed Toad remains open awaiting for user input to commit/rollback open transactions.

Turn on Auto Commit in Toad, located at the bottom-left corner of main screen.
OR
If prompted with commit/rollback warning, check the checkbox inside warning window to no longer be prompted.

SQL Server transactions can be open transactions or place table locks and so Toad will show the commit/rollback prompt. There are database timeout settings that can be used to control how database treats such transactions::
1. Select Tools | Options menu option
2. Drill down to Database | Timeouts section
3. For Lock Timeout and Open Transaction Time, change to 1 second and hit Apply and OK