System Stored Procedures (System) (Level 3)

Installing SQL Server

Installing SQL Server
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