Any suggestions? Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
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

© 2016 Microsoft