Export (0) Print
Expand All
Expand Minimize

sp_droptask

SQL Server 2000

sp_droptask is provided for backward compatibility only. For information about the Microsoft SQL® Server™ version 7.0 replacement procedures, see SQL Server Backward Compatibility Details.

Removes a scheduled task.

Important  For information about syntax used in earlier versions of SQL Server, see the Microsoft SQL Server Transact-SQL Reference for version 6.x.

Remarks

If you create a task by using sp_addtask, that task must be deleted only by using sp_droptask. For task management, use SQL Server Enterprise Manager.

Permissions

Execute permissions default to the public role.

See Also

sp_addtask

sp_helptask

sp_purgehistory

sp_updatetask

System Stored Procedures

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