Gets or sets the maximum number of times a job step is retried before it is returned with a completion status of failure.
命名空間: Microsoft.SqlServer.Management.Smo.Agent
組件: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)
語法
'宣告
Public Property RetryAttempts As Integer
public int RetryAttempts { get; set; }
public:
property int RetryAttempts {
int get ();
void set (int value);
}
/** @property */
public int get_RetryAttempts ()
/** @property */
public void set_RetryAttempts (int value)
public function get RetryAttempts () : int
public function set RetryAttempts (value : int)
屬性值
An Int32 value that specifies the number of times a job step is retried.
備註
Microsoft SQL Server Agent job steps are assigned simple logic determining job execution behavior on step success or failure.
If the job step is completed successfully, job execution branches to follow the on-success action for the step. If the number of execution attempts reaches the value of the RetryAttempts property, job execution branches to follow the on-failure action for the step.
When a job step fails, and the step is flagged for retry, SQL Server Agent can pause between execution attempts for the length of time specified in the RetryInterval property
只有 Microsoft .NET Framework 2.0 版支援此命名空間、類別或成員。
範例
How to: Create a Job with Steps and a Schedule in Visual Basic .NET
執行緒安全性
Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
平台
開發平台
如需受支援的平台清單，請參閱＜安裝 SQL Server 2005 的硬體和軟體需求＞。
目標平台
如需受支援的平台清單，請參閱＜安裝 SQL Server 2005 的硬體和軟體需求＞。
請參閱
參考
JobStep Class
JobStep Members
Microsoft.SqlServer.Management.Smo.Agent Namespace
其他資源
Scheduling Automatic Administrative Tasks in SQL Server Agent
自動化管理工作 (SQL Server Agent)
sp_help_jobstep (Transact-SQL)