共用方式為


JobServer.SysAdminOnly 屬性

Gets the Boolean property value that specifies whether CmdExec and ActiveX commands can only be executed by members of the sysadmin fixed server role.

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

語法

'宣告
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public ReadOnly Property SysAdminOnly As Boolean 
    Get
'用途
Dim instance As JobServer 
Dim value As Boolean 

value = instance.SysAdminOnly
[SfcPropertyAttribute(SfcPropertyFlags.Standalone)]
public bool SysAdminOnly { get; }
[SfcPropertyAttribute(SfcPropertyFlags::Standalone)]
public:
property bool SysAdminOnly {
    bool get ();
}
[<SfcPropertyAttribute(SfcPropertyFlags.Standalone)>]
member SysAdminOnly : bool
function get SysAdminOnly () : boolean

屬性值

型別:System.Boolean
A Boolean value that specifies whether CmdExec and ActiveX command can be executed by sysadmin only or not.If True, CmdExec and ActiveX require sysadmin permissions only.If False (default), CmdExec and ActiveX are not restricted to sysadmin permissions.

備註

The SysAdminOnly property throws an exception if set or retrieved.

範例

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

請參閱

參考

JobServer 類別

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

其他資源

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

SQL Server Agent 預存程序 (Transact-SQL)