This topic has not yet been rated - Rate this topic

JobFilter.DateFindOperand Property

SQL Server 2008 R2

Gets or sets the operator used to evaluate date constraints in the job filter.

Namespace: Microsoft.SqlServer.Management.Smo.Agent
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

C++

JScript

public FindOperand DateFindOperand { get; set; }

Property Value

Type: Microsoft.SqlServer.Management.Smo.Agent.FindOperand
A FindOperand object value that specifies the way that dates are evaluated in the job filter.

Remarks

A job filter can be applied to the JobServer object's EnumJobs method to restrict the returned enumerated list. When the constraint is a date property such as DateJobCreated the FindOperand is used to specify whether the enumerated list is restricted to jobs created on an earlier, later, or equal date.

Examples

Scheduling Automatic Administrative Tasks in SQL Server Agent

Reference

JobFilter Class

Microsoft.SqlServer.Management.Smo.Agent Namespace

Other Resources

Automating Administrative Tasks (SQL Server Agent)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD