Chat now with support
Chat with Support

SQL Optimizer for SAP ASE 3.9.1 - Installation Guide

Add Jobs to SQL Scanner

The Add Jobs wizard enables you to select the database objects, abstract plan groups, Inspectors from the SQL Inspector, Collectors from the SQL Collector for Monitor Server module, SQL Inspector files, and application source or binary files that you want to scan. The Summary page enables you to control the user and database used.

To add Jobs to the SQL Scanner window

Click image\B_AddJobs.gif to display the Add Jobs wizard. The Add Jobs wizard displays automatically when the SQL Scanner window is opened if no Job exists in the SQL Scanner window.

Add Options

The following pages are for selecting which database objects, abstract plan groups, or files to scan.

Database Objects

Abstract Plan Group

SQL Collectors from the SQL Collector for Monitor Server

SQL Inspectors

Source Code

Summary Options

The summary page is for selecting to scan the jobs with the current database and user.

Use Current DB & User

When you have selected a large number of database objects, it may take a long to insert all of them into the SQL Scanner window. If you click Abort, the objects and files that have already been inserted to the SQL Scanner window remain in the window.

 

Related Topics

Related Documents