Job.CurrentRunRetryAttempt Property
SQL Server 2008 R2
Gets the number of times Microsoft SQL Server Agent has attempted to run the job unsuccessfully.
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Expensive|SfcPropertyFlags.Standalone)] public int CurrentRunRetryAttempt { get; }
Property Value
Type: System.Int32An 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
