PurgeJobHistory Method

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 PurgeJobHistory method removes system records maintaining execution history for all Microsoft SQL Server Agent jobs, or those matching the filter criteria specified.

Syntax

object
.PurgeJobHistory( [ Filter ] )

Parts

  • object
    Expression that evaluates to an object in the Applies To list.
  • Filter
    Optional. A JobHistoryFilter object that constrains record removal to those records identified by the criteria set in the object.

Prototype (C/C++)

HRESULT PurgeJobHistory(
LPSQLDMOJOBHISTORYFILTER pFilter = NULL);

Hinweise

For more information about using the JobHistoryFilter object properties to identify job history records, see JobHistoryFilter Object.

Applies To:

JobServer Object