Share via

Job.CategoryType Property

  • Article

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

Namespace:  Microsoft.SqlServer.Management.Smo.Agent
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Expensive Or SfcPropertyFlags.Standalone)> _
Public Property CategoryType As Byte 
    Get 
    Set
'Usage
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)

Property Value

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

Remarks

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

Examples

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

See Also

Reference

Job Class

Microsoft.SqlServer.Management.Smo.Agent Namespace

Other Resources

Automated Administration Tasks (SQL Server Agent)

sp_add_job (Transact-SQL)

Scheduling Automatic Administrative Tasks in SQL Server Agent