Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

System Stored Procedures (Tasks) (Level 1)

System Stored Procedures (Tasks) (Level 1)

Replace the following unsupported Microsoft® SQL Server™ 6.x task-related system stored procedures with the corresponding SQL Server 2000 job-related system stored procedures.

SQL Server 6.x SQL Server 2000
sp_addalert sp_add_alert
sp_addnotification sp_add_notification
sp_addoperator sp_add_operator
sp_dropalert sp_delete_alert
sp_dropnotification sp_delete_notification
sp_dropoperator sp_delete_operator
sp_helpalert sp_help_alert
sp_helphistory sp_help_jobhistory
sp_helpnotification sp_help_notification
sp_helpoperator sp_help_operator
sp_purgehistory sp_purge_jobhistory
sp_runtask sp_start_job
sp_stoptask sp_stop_job
sp_updatealert sp_update_alert
sp_updatenotification sp_update_notification
sp_updateoperator sp_update_operator

Task management has been changed to job management.

© 2015 Microsoft