Chat now with support
Chat with Support

We are currently preforming website maintenance, any feature requiring sign-in is temporarily unavailable, if you have an issue requiring immediate assistance please call Technical Support.

SQL Optimizer for SAP ASE 3.9.1 - User Guide

Introduction Tutorials Preferences Editor Functions SQL Information and Functions Performance Monitor SQL Inspector SQL Collector for Monitor Server SQL Scanner Index Advisor SQL Optimizer
SQL Optimizer Overview Optimization Engine Common Coding Errors in SQL Statements What Function Should l Use to Retrieve the Run Time? Unsatisfactory Performance Results SQL Optimizer Functions SQL Editor Optimized SQL Activity Log
SQL Worksheet SQL Formatter Database Explorer Code Finder Object Extractor SQL Repository Index Impact Analyzer Index Usage Analyzer Configuration Analyzer Migration Analyzer Abstract Plan Manager User-Defined Temp Tables SQL History Legal Information

Mark and Unmark All Jobs

The image\I_BlackCheckmark.gif black checkmark is used to indicate that the job is marked; any appended symbol is removed to indicate that the job is unmarked in the SQL Scanner window.

To mark or unmark all Jobs

Select Group | Mark All [Ctrl + M] or select Group | Unmark All [Ctrl + U].


Related Topic

Move or Copy Jobs to Other Group

To move or copy Jobs in the SQL Scanner to another Group

  1. Mark the Jobs to be moved or copied.

  2. Select Group | Move to Other Group or select Group | Copy to Other Group.

  3. Select Group where the Jobs are being moved or copied from the list.

  4. Click OK.


Related Topic

Switch Database and User

To change the database used to scan a particular Job in the SQL Scanner window

  1. Right-click the job and select Use Database.

  2. Select the database name.

To change the user used to scan a particular Job in the SQL Scanner window

  1. Right-click the job and select Set User.

  2. Select the user name.


Related Topic

Modify a Job

To modify a Job in the SQL Scanner window

Right-click and select Modify.

The Modify Job dialog field allows you to do the following:

  • Modify Job description

  • Change the file type

  • Eliminate duplicate SQL while scanning.

When modifications are made to a Job, it must be rescanned.


Related Topic

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating