Edit

Share via

sp_manage_jobs_by_login (Transact-SQL)

  • Article

Applies to: SQL Server

Deletes or reassigns jobs that belong to the specified login.

Transact-SQL syntax conventions

Syntax

sp_manage_jobs_by_login
    [ @action = ] 'action'
    , [ @current_owner_login_name = ] N'current_owner_login_name'
    [ , [ @new_owner_login_name = ] N'new_owner_login_name' ]
[ ; ]

Arguments

[ @action = ] 'action'

The action to take for the specified login. @action is varchar(10), with no default. When @action is DELETE, sp_manage_jobs_by_login deletes all jobs owned by @current_owner_login_name. When @action is REASSIGN, all jobs are assigned to @new_owner_login_name.

[ @current_owner_login_name = ] N'current_owner_login_name'

The login name of the current job owner. @current_owner_login_name is sysname, with no default.

[ @new_owner_login_name = ] N'new_owner_login_name'

The login name of the new job owner. @new_owner_login_name is sysname, with a default of NULL. Use this parameter only if @action is REASSIGN. @new_owner_login_name is sysname, with a default of NULL.

Return code values

0 (success) or 1 (failure).

Result set

None.

Permissions

To run this stored procedure, users must be granted the sysadmin fixed server role.

Examples

The following example reassigns all jobs from danw to françoisa.

USE msdb;
GO

EXEC dbo.sp_manage_jobs_by_login
    @action = N'REASSIGN',
    @current_owner_login_name = N'danw',
    @new_owner_login_name = N'françoisa';
GO

Related content