System Stored Procedures (System) (Level 3)
| SQL Server 6.x | SQL Server 2000 |
|---|---|
| Job management was called task management, and several system stored procedures allowed system administrators to create and manage tasks. | The task management system stored procedures are no longer documented and are included for backward compatibility only.
Even though Microsoft® SQL Server™ 2000 supports the task management system stored procedures (sp_addtask, sp_droptask, sp_helptask, sp_reassigntask, and sp_updatetask) for scheduling and managing SQL Server jobs, consider using either SQL Server Enterprise Manager or the job-related system stored procedures listed in the following table for managing jobs. |
The task-related stored procedures listed in the SQL Server 6.x column below have been replaced by the corresponding job-related stored procedures shown in the SQL Server 2000 column.
| SQL Server 6.x | SQL Server 2000 |
|---|---|
| sp_addtask | sp_add_job sp_add_jobstep sp_add_jobschedule sp_start_job |
| sp_droptask | sp_delete_job sp_delete_jobstep sp_delete_jobschedule |
| sp_helptask | sp_help_jobhistory sp_help_jobschedule sp_help_jobstep |
| sp_reassigntask | sp_purge_jobhistory sp_stop_job |
| sp_updatetask | sp_update_job sp_update_jobstep sp_update_jobschedule |