Returns history only for those tasks owned by the calling user. This procedure prevents sensitive information stored in the systasks table from being displayed to all users.
The system administrator retains the ability to view the histories of all scheduled tasks.
For additional syntax information for sp_helphistory, see the Microsoft SQL Server Transact-SQL Reference.