Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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
Microsoft.SqlServer.Management.Smo.Agent Namespace
Other Resources
Automated Administration Tasks (SQL Server Agent)
Scheduling Automatic Administrative Tasks in SQL Server Agent