sp_helptask is provided for backward compatibility only. For 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 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.
| sp_addtask | sp_purgehistory |
| sp_droptask | System Stored Procedures |
| sp_updatetask |