Devart Forums

When I run some long procedures or script, I would love to know where the job is in the process. Right now all I see is a huge list of "Execute Succeeded {elapsed time]" statements. Therefore, I would like to be able to send specific text to the output window.

For example, Before starting a complex update that takes a hour to run, I would like to send the message "Starting Table XYZ Update" and include the time it started. Then as it progresses write "Completed Step A", "Complete Step B", etc.

Any way to do this?
Thanks,
Jim

You can log queries sent by dbForge Studio for MySQL as follows:

1. Select 'Tools -> Options' from the main menu. The 'Options' window opens.
2. Navigate to the 'Environment -> Output' branch.
3. Select the 'Log application errors' and 'Write queries sent by the program to the SQL Log' options. To open SQL Log, select 'View -> Output' from the main menu and switch to the 'SQL Log' tab in the 'Output' tool window.
4. Unselect the 'Delete application log after closing' option.
5. Click 'OK'.

The log file is saved in the directory with the application executable file (by default '%programfiles%\Devart\dbForge Studio for MySQL\').

Thanks, but I don't want to go an open a log file every time I run a job. I want to look in the main output window where the success/failure of each command is logged.

As we mentioned in the step 3, this can be monitored in the 'SQL Log' tab of the 'Output' tool window.