Freigeben über

JobCategories Collection

  • Artikel

Dieses Feature wird in einer zukünftigen Version von Microsoft SQL Server entfernt. Verwenden Sie dieses Feature 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

Methods

Add Method

Refresh Method

Item Method

Remove Method (Collections)

ItemByID Method

 

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

  1. Use the Remove method of the JobCategories collection, as in:

    oJobServer.JobCategories.Remove("Northwind_Backup")
    ms141151.note(de-de,SQL.90).gifHinweis:
    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)