PurgeJobHistory Method

SQL-DMO

SQL-DMO

PurgeJobHistory Method

The PurgeJobHistory method removes system records maintaining execution history for all Microsoft® SQL Server™ 2000.Agent jobs, or those matching the filter criteria specified.

Applies To
JobServer Object
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);

Remarks

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