Home Dashboard Directory Help
Search

sp_help_job BOL documentation error by Wayne Sheffield


Status: 

Active


1
0
Sign in
to vote
Type: Bug
ID: 772627
Opened: 11/28/2012 7:30:34 PM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description

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
Details
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

Thanks
Sethu Srinivasan [MSFT]
SQL Server
Sign in to post a workaround.