共用方式為


JobStep.DatabaseUserName 屬性

Gets or sets the database user account that the job step assumes when executing the command string.

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

語法

'宣告
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public Property DatabaseUserName As String 
    Get 
    Set
'用途
Dim instance As JobStep 
Dim value As String 

value = instance.DatabaseUserName

instance.DatabaseUserName = value
[SfcPropertyAttribute(SfcPropertyFlags.Standalone)]
public string DatabaseUserName { get; set; }
[SfcPropertyAttribute(SfcPropertyFlags::Standalone)]
public:
property String^ DatabaseUserName {
    String^ get ();
    void set (String^ value);
}
[<SfcPropertyAttribute(SfcPropertyFlags.Standalone)>]
member DatabaseUserName : string with get, set
function get DatabaseUserName () : String 
function set DatabaseUserName (value : String)

屬性值

型別:System.String
A String value that specifies the name of the database user.

備註

A Microsoft SQL Server Agent job step can execute by assuming the rights of a database user. Change the DatabaseUserName property to set the user execution context for a job step. The default value is dbo, and job steps execute using database owner permissions.

範例

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

請參閱

參考

JobStep 類別

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

其他資源

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

sp_help_jobstep (Transact-SQL)