共用方式為

JobServer.ReassignJobsByLogin(String, String) Method

  • Reference

Definition

Namespace:
Microsoft.SqlServer.Management.Smo.Agent
Assembly:
Microsoft.SqlServer.Smo.dll
Package:
Microsoft.SqlServer.SqlManagementObjects v150.18208.0
Package:
Microsoft.SqlServer.SqlManagementObjects v160.2004021.0

The ReAssignJobsByLogin method changes ownership for any SQLServerAgent jobs currently owned by a login.

public void ReassignJobsByLogin (string oldLogin, string newLogin);
member this.ReassignJobsByLogin : string * string -> unit
Public Sub ReassignJobsByLogin (oldLogin As String, newLogin As String)

Parameters

oldLogin
String

String that specifies a login currently owning jobs.

newLogin
String

String that specifies a login with job creation rights. The login specified will receive ownership.

Applies to