sp_addtask is provided for backward compatibility only. For information about the replacement procedures for Microsoft® SQL Server™ version 7.0, see SQL Server Backward Compatibility Details.
Creates 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.
If you create a task by using sp_addtask, the task can be deleted only by sp_droptask. For task management, use SQL Server Enterprise Manager.
Execute permissions default to the public role.
| sp_droptask | sp_purgehistory |
| sp_helphistory | sp_updatetask |
| sp_helptask | System Stored Procedures |