To abort the scanning process
Click .
The Abort Scan function may take a few seconds to complete, as time is needed to close down all the necessary processes.
To search for a specified text in all Jobs in the Job Manager window
Select Job | Find Job.
Enter the text string to be located.
Click Find.
All the Jobs and number of the corresponding SQL statements will be listed.
The Group summary report provides a statistical list of all the Jobs and SQL statements scanned within the Group.
To view the summary information
In the Job Manager Report | Group Summary window, select .
The Group progtfrhnbperties provides information about SQL Scanner Group.
To view the Group properties information
Select a Group in the Group Manager window.
Right-click and select Properties.
The Group Properties window displays the following information:
| Item | Description | 
|---|---|
| Name | Group name. | 
| Description | Group description. | 
| Last modified | Last modified date and time. | 
| Size | Total size of the Jobs within the Group. | 
| Data Directory | Directory where the files are stored. | 
| Version | Version number of SQL Optimizer when the Group was created. | 
| Total Job | Total number of Jobs. | 
| Completed | Total number of Jobs that were scanned. | 
| Remaining | Total number of Jobs that had not been scanned. | 
Displays a pie chart showing the number and percentage of Problematic, Complex, Simple and invalid SQL statements.