Export (0) Print
Expand All
Expand Minimize


SQL Server 2000

sp_helptask is provided for backward compatibility only. For more information about the procedures used in Microsoft® SQL Server™ version 7.0, see SQL Server Backward Compatibility Details.

Provides information about one or more tasks that the user owns. sp_helptask prevents sensitive information stored in the systasks table from being returned to all users.

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.


Execute permissions default to the public role. Anyone who can execute this procedure can also create, delete, or update a job, job step, job category, job schedule, job server, task, or job history information.

See Also





System Stored Procedures

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2015 Microsoft