sp_reassigntask

Transact-SQL Reference

Transact-SQL Reference

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.

See Also

sp_update_job

System Stored Procedures