Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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
EXECUTE dbo.sp_manage_jobs_by_login
@action = N'REASSIGN',
@current_owner_login_name = N'danw',
@new_owner_login_name = N'françoisa';
GO