SQL Maestro Group / Products / MS SQL Server / MS SQL Maestro / Documentation

MS SQL Maestro online Help

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

•	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

•	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

•	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.