• Artikel

JobCategories Collection

Diese Funktion wird in zukünftigen Versionen von Microsoft SQL Server nicht mehr bereitgestellt. Verwenden Sie diese Funktion beim Entwickeln neuer Anwendungen nicht, und planen Sie das Ändern von Anwendungen, in denen es zurzeit verwendet wird.

The JobCategories collection contains Category objects that expose a SQL Server Agent job-organizing method.

SQL-DMO-Objektmodell, das das aktuelle Objekt anzeigt

Hinweise

For SQL Server Agent, categories offer a mixed system and user-defined method for grouping alerts, operators, and jobs. When using SQL Distributed Management Objects (SQL-DMO) to administer jobs, a job category can be used to filter job lists that streamline administrative tasks, such as job execution.

With the JobCategories collection, you can:

  • Create a new category for SQL Server Agent jobs.

  • Remove a SQL Server Agent job category.

To remove a job category

  • Use the Remove method of the JobCategories collection, as in:

    oJobServer.JobCategories.Remove("Northwind_Backup")
    HinweisHinweis

    When using the Remove method of the JobCategories collection, existing SQL Server Agent jobs are reclassified as necessary. If a locally-defined job exhibits the removed category, it is assigned the system-defined category [Uncategorized (Local)] when the existing category is removed. If a job targets multiple target servers, it is assigned the system-defined category [Uncategorized (Multi-Server)] when the existing category is removed.

When using the Item or Remove method, the JobCategories collection supports member identification using either name or ordinal reference syntax. For example:

Set oCategory = oJobServer.JobCategories("Northwind_Backup")

Or

Set oCategory = oJobServer.JobCategories(7)