sp_addtask

Transact-SQL Reference

Transact-SQL Reference

sp_addtask

Creates a scheduled task.

sp_addtask 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.

Important  For more 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, the task can be deleted only by sp_droptask. For task management, use SQL Server Enterprise Manager.

Permissions

Execute permissions default to the public role.

See Also

sp_droptask

sp_helphistory

sp_helptask

sp_purgehistory

sp_updatetask

System Stored Procedures