Online Documentation for All SQLManager.net Products

Selection


This page allows you to edit object selection for indices reorganization.

 

Editing Service task template - Reorganizing indices - Databases

 

 

Servers

 

Select the servers to run the operation on. If the servers name icon is grayed out the Angel service is not run (installed) or there is no connection to the server.

Note: Selecting servers is not available in Template mode. It is selected on applying the Step Template in Policy.

 

Databases and objects

 

All

Use this option to select both: system and user objects.

 

All system

This option indicates that only system objects should be selected.

 

All user

Select this option to select user objects only.

 

By mask

This option allows defining objects selection by mask. Use * for a set of any characters and ? for any single character in the object name.

 

By list

This option allows you to select objects manually.

If you are creating a step template then you can add a database to the list by using the AddItem button or Ins key.

 

Note: The server is selected on applying the Step Template in Policy.

 

When you are editing a step on creating a policy from template then if the database(s)/table(s)/view(s) defined on the Selecting objects step are missed on the selected server the list of database(s)/table(s)/view(s) will be the following.

 

Editing Service task - Clean mismatches (tables and views)

 

 

Click the Clean Mismatches button to delete the missed database(s)/table(s)/view(s) from the list for the policy cannot be executed for them.