Propriété Job.CurrentRunRetryAttempt

Gets the number of times Microsoft SQL Server Agent has attempted to run the job unsuccessfully.

Espace de noms :  Microsoft.SqlServer.Management.Smo.Agent
Assembly :  Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)

Syntaxe

'Déclaration
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Expensive Or SfcPropertyFlags.Standalone)> _
Public ReadOnly Property CurrentRunRetryAttempt As Integer 
    Get
'Utilisation
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

Valeur de propriété

Type : System.Int32
An Int32 value that specifies the number of times SQL Server Agent has attempted to run the job unsuccessfully.

Exemples

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

Voir aussi

Référence

Job Classe

Espace de noms Microsoft.SqlServer.Management.Smo.Agent

Autres ressources

Tâches d'administration automatisée (Agent SQL Server)

sp_add_job (Transact-SQL)

Planification des tâches administratives automatiques dans l'Agent SQL Server