Export (0) Print
Expand All
Expand Minimize


SQL Server 2000

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


System Stored Procedures

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2015 Microsoft