Condividi tramite


Proprietà Job.CategoryType

Gets or sets the type of category, with respect to local or multiserver jobs.

Spazio dei nomi  Microsoft.SqlServer.Management.Smo.Agent
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Sintassi

'Dichiarazione
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Expensive Or SfcPropertyFlags.Standalone)> _
Public Property CategoryType As Byte 
    Get 
    Set
'Utilizzo
Dim instance As Job 
Dim value As Byte 

value = instance.CategoryType

instance.CategoryType = value
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Expensive|SfcPropertyFlags.Standalone)]
public byte CategoryType { get; set; }
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Expensive|SfcPropertyFlags::Standalone)]
public:
property unsigned char CategoryType {
    unsigned char get ();
    void set (unsigned char value);
}
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Expensive|SfcPropertyFlags.Standalone)>]
member CategoryType : byte with get, set
function get CategoryType () : byte 
function set CategoryType (value : byte)

Valore proprietà

Tipo: System.Byte
A Byte value that specifies the job category type.

Osservazioni

The job category type is a byte value that is determined by the CategoryTypeCategoryType enumeration.

Esempi

The following code example specifies that the job is local.

C#

Job jb = new Job();
jb.CategoryType = CategoryType.LocalJob;

PowerShell

$jb = new-object Microsoft.SqlServer.Management.Smo.Agent.Job
$jb.CategoryType = [Microsoft.SqlServer.Management.Smo.Agent.CategoryType]::LocalJob

Vedere anche

Riferimento

Job Classe

Spazio dei nomi Microsoft.SqlServer.Management.Smo.Agent

Altre risorse

Automatizzazione delle attività amministrative (SQL Server Agent)

sp_add_job (Transact-SQL)

Pianificazione delle attività amministrative automatiche in SQL Server Agent