CurrentRunRetryAttempt 属性
Gets the number of times Microsoft SQL Server Agent has attempted to run the job unsuccessfully.
命名空间: Microsoft.SqlServer.Management.Smo.Agent
程序集: Microsoft.SqlServer.Smo(在 Microsoft.SqlServer.Smo.dll 中)
语法
声明
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Expensive Or SfcPropertyFlags.Standalone)> _
Public ReadOnly Property CurrentRunRetryAttempt As Integer
Get
用法
Dim instance As Job
Dim value As Integer
value = instance.CurrentRunRetryAttempt
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Expensive|SfcPropertyFlags.Standalone)]
public int CurrentRunRetryAttempt { get; }
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Expensive|SfcPropertyFlags::Standalone)]
public:
property int CurrentRunRetryAttempt {
int get ();
}
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Expensive|SfcPropertyFlags.Standalone)>]
member CurrentRunRetryAttempt : int
function get CurrentRunRetryAttempt () : int
属性值
类型:System. . :: . .Int32
An Int32 value that specifies the number of times SQL Server Agent has attempted to run the job unsuccessfully.
示例
The following code example displays the number of times that that the job has failed.
C#
Server srv = new Server("(local)");
Job jb = new Job(srv.JobServer, "Test Job");
jb.Create();
Console.WriteLine(jb.CurrentRunRetryAttempt);
PowerShell
$srv = new-object Microsoft.SqlServer.Management.Smo.Server("(local)")
$jb = new-object Microsoft.SqlServer.Management.Smo.Agent.Job($srv.JobServer, "Test Job")
$jb.Create()
Write-Host $jb.CurrentRunRetryAttempt