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

SQL Scanner Window

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

SQL Scanner Window

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

SQL Scanner Window

Placing Bookmarks in SQL Scanner

Place Bookmarks in SQL Scanner

Bookmarks are used to mark a Job in the SQL Scanner window to indicate such things as:

• You are currently working on a Job.

• You have finished reviewing a Job.

• You have determined the critical Jobs to be reviewed first.

If the row contains a bookmark, the complete row text is displayed in fuchsia color. You can have multiple bookmarks.

To place or remove a bookmark in the SQL Scanner window

Right-click on a job and select Add/Remove Bookmark.

Related Topic

SQL Scanner Window