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.