Any suggestions? Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
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

© 2015 Microsoft