sp_reassigntask
This procedure is provided for backward compatibility only. For more information about the replacement procedures for Microsoft® SQL Server™ version 7.0, see SQL Server Backward Compatibility Details.
sp_reassigntask changes the owner of a job (formerly referred to as a task), or all jobs owned by a specified login. If a job was created by using sp_addtask, the job must be deleted by using sp_droptask.
Important For syntax information used in earlier versions of SQL Server, see the Microsoft® SQL Server™ version 6.x Transact-SQL Reference. For task management, use SQL Server Enterprise Manager.