共用方式為

Job.CategoryType 屬性

  • 發行項

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

命名空間：  Microsoft.SqlServer.Management.Smo.Agent
組件：  Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)

語法

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

屬性值

型別：System.Byte
A Byte value that specifies the job category type.

備註

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

範例

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

請參閱

參考

Job 類別

Microsoft.SqlServer.Management.Smo.Agent 命名空間

其他資源

自動化管理工作 (SQL Server Agent)

sp_add_job (Transact-SQL)

使用 SQL Server Agent 排程自動管理工作