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.
The Job properties provides information about a SQL Scanner Job.
To view the Job properties information
In the Job Manager window, select the Job.
Right-click and select Properties.
The Job Properties window displays the following information:
Item |
Description |
---|---|
Name |
Job name. |
Type |
Type of Job scanned (text/binary file, COBOL file, DB2 Event Monitor, database object). |
Description |
Job description. |
Last modified |
Last modified date and time. |
Size |
Job size. |
Data Directory |
Directory where the files are stored. |
Status |
Job status. |
Version |
Version number of SQL Optimizer when the Job was last scanned. |
Displays a pie chart showing the number and percentage of Problematic, Complex, Simple, and Invalid SQL statements.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Conditions d’utilisation Confidentialité Cookie Preference Center