Transact-SQL Reference

sp_helptask

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.

Permissions

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

sp_addtask

sp_droptask

sp_purgehistory

sp_updatetask

System Stored Procedures