Compartilhar via


Método JobServer.ReassignJobsByLogin

Changes ownership for any SQL Server Agent job currently owned by a SQL Server login.

Namespace:  Microsoft.SqlServer.Management.Smo.Agent
Assembly:  Microsoft.SqlServer.Smo (em Microsoft.SqlServer.Smo.dll)

Sintaxe

'Declaração
Public Sub ReassignJobsByLogin ( _
    oldLogin As String, _
    newLogin As String _
)
'Uso
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
)

Parâmetros

Comentários

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.

Exemplos

Agendando tarefas administrativas automáticas no SQL Server Agent

Consulte também

Referência

JobServer Classe

Namespace Microsoft.SqlServer.Management.Smo.Agent

Outros recursos

Tarefas de administração automatizadas (SQL Server Agent)

sp_delete_job (Transact-SQL)