Export (0) Print
Expand All
Expand Minimize

sp_reassigntask

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

sp_update_job

System Stored Procedures

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