共用方式為


MinimumRetries Property

未來的 Microsoft SQL Server 發行版本將不再提供此功能。請避免在新的開發工作中使用此功能,並計劃修改目前使用此功能的應用程式。

The MinimumRetries property specifies filtering by the number of times SQL Server Agent attempted to execute a scheduled job prior to a successful execution.

語法

object
.MinimumRetries [= value]

Parts

  • object
    an expression that evaluates to an object in the Applies To list
  • value
    A long integer

Data Type

Long

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetMinimumRetries(LPLONG pRetVal);
HRESULT SetMinimumRetries(long NewValue);

備註

Set the MinimumRetries property to filter the job execution history list based on failed execution attempts. For example, set the MinimumRetries property to 1 to list only those jobs that did not successfully execute on the first attempt.

If the MinimumRetries property is 0, the property is not used as part of job execution history filtering.

Applies To:

JobHistoryFilter Object