Share via

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
)

매개 변수

주의

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.

예

SQL Server 에이전트에서 자동 관리 태스크 예약

참고 항목

참조

JobServer 클래스

Microsoft.SqlServer.Management.Smo.Agent 네임스페이스

관련 자료

관리 태스크 자동화(SQL Server 에이전트)

sp_delete_job(Transact-SQL)