sp_help_job BOL documentation error - by Wayne Sheffield

Status : 


Sign in
to vote
ID 772627 Comments
Status Active Workarounds
Type Bug Repros 0
Opened 11/28/2012 7:30:34 PM
Access Restriction Public


In the BOL for sp_help_job (http://msdn.microsoft.com/en-us/library/ms186722.aspx) it states that you must provide either @job_id or @job_name, but not both. Actually, you can supply no parameters to retrieve information about all jobs.

Furthermore, in the code for sp_help_job, is the following remark:
  -- The caller must supply EITHER job name (or job id) and aspect OR one-or-more of the set
  -- parameters OR no parameters at all
Sign in to post a comment.
Posted by Sethu Srinivasan on 11/29/2012 at 8:25 AM
Thanks for reporting this issue. We shall work on this issue and keep you posted

Sethu Srinivasan [MSFT]
SQL Server