When you execute SQL in the Editor or the Query Builder, a log of executed commands displays in the Messages tab.
The Messages tab is cleared automatically each time you execute a full script. However, if you execute a partial script multiple times, each execution displays in the tab.
If a script contains message or notice statements, the messages/notices display in the Messages tab.
Note: For some providers, the message timestamp may not reflect the actual time the message was raised. For example, in ODBC connections, all messages within an execution will have the same timestamp because Toad retrieves them after execution.
To switch between the grid and a text view of the output, right-click the Messages tab and select Text Output. This is useful when using PRINT statements.
To re-execute a statement, right-click the statement in the Messages tab (non-text output) and select Re-execute.
When you execute an Automation script, the execution log displays in the Log tab of the Automation window. See Execute and Schedule Automation Scripts and Automate Tasks for more information about Automation scripts.
To troubleshoot errors encountered when executing scheduled Automation scripts, see Troubleshooting Scheduled Automation Scripts.
Tip: To switch between the grid and a text view of the log, right-click in the Log tab and select Text Output.
When you run, or test-run, an Automation script on Toad Intelligence Central (TIC), the execution log displays in a separate pane. To troubleshoot Automation script execution errors for scripts on TIC, see Troubleshoot Scripts on Intelligence Central.
You can use the Output window (View | Output) to view logs and messages from different sources. See View Output Window for more information.