JobServer.ReassignJobsByLogin 方法
Changes ownership for any SQL Server Agent job currently owned by a SQL Server login.
命名空间： Microsoft.SqlServer.Management.Smo.Agent
程序集： Microsoft.SqlServer.Smo（在 Microsoft.SqlServer.Smo.dll 中）
语法
声明
Public Sub ReassignJobsByLogin ( _
oldLogin As String, _
newLogin As String _
)
用法
Dim instance As JobServer
Dim oldLogin As String
Dim newLogin As String
instance.ReassignJobsByLogin(oldLogin, _
newLogin)
public void ReassignJobsByLogin(
string oldLogin,
string newLogin
)
public:
void ReassignJobsByLogin(
String^ oldLogin,
String^ newLogin
)
member ReassignJobsByLogin :
oldLogin:string *
newLogin:string -> unit
public function ReassignJobsByLogin(
oldLogin : String,
newLogin : String
)
参数
- oldLogin
类型：System.String
A String value that specifies the old SQL Server login.
- newLogin
类型：System.String
A String value that specifies the new SQL Server login.
注释
By default, any SQL Server login has membership, through the user guest, in the public role of the system database maintaining SQL Server Agent jobs (msdb). When a SQL Server user is created in msdb, jobs created by the user mapping the login are owned by the login, not the user.
Reassigning SQL Server Agent job ownership by using the ReassignJobsByLogin method requires appropriate permission. The SQL Server login used for the current connection must be a member of the fixed role sysadmin.
示例
请参阅
参考
Microsoft.SqlServer.Management.Smo.Agent 命名空间