Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Lynn Armbruster: "Thank you. I found Maestro easy to use and so far a great tool".
DavidNR: "MS SQL Maestro is a great app. Loved it. I only used it for its blob support thus far, very nice and very fast".

More

Add your opinion

MS SQL Maestro online Help

Prev Return to chapter overview Next

Categories

The Category object represents the attributes of a SQL Server Agent alert category, job category or operator category.

 

Microsoft SQL Server provides categories to help you organize your jobs, alerts and operators for easy filtering and grouping. For example, you can organize all your database backup jobs in the Database Maintenance category. You can also create your own categories. Multiserver categories exist only on a master server. There is only one default job category available only on a master server: [Uncategorized (Multi-Server)].

 

Note: Alerts are recategorized as necessary when an alert category is removed. Any alerts previously exhibiting the removed category exhibit the category [Uncategorized] after the removing.
 

 

New categories are created within Create Category Wizard. In order to run this wizard you should either

 

select the Categories list or any object from that list and then use the Create New Category item from the popup menu

or

open the server in Server Editor and the Categories tab there and press Insert or select the Create New Category item from the popup menu (Alternatively, use the corresponding link of the Navigation Bar).

 

 

 

Categories are edited within Category Editor. In order to open the editor you should either

 

select the category for editing in the explorer tree (type the first letters of the category name for quick search);
select the Edit Category item from the popup menu

or

open the server in Server Editor and the Categories tab there;
select the category to edit;
press the Enter key or select the Edit Category item from the popup menu (alternatively, you can use the corresponding link of the Navigation Bar).

 

 

 

To drop the existing category:

 

select the category to drop in the explorer tree;
select the Drop Category item from the popup menu

or

open the server in Server Editor and the Categories tab there;
select the category to drop;
press Delete or select the Drop Category item from the popup menu (alternatively, you may use the corresponding link of the Navigation Bar)

 

and confirm dropping in the dialog window.

 



Prev Return to chapter overview Next