Search

sp_help_job BOL documentation error by Wayne Sheffield

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)
0
User(s) can reproduce this bug
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 (expand)

Product Language

English

Version

SQL Server 2012 - Developer Edition

Category

Documentation

Operating System

Windows 7 Ultimate

Operating System Language

US English

Steps to Reproduce

N/A

Actual Results

N/A

Expected Results

N/A

Platform

X64

Virtualization

 
File Attachments
0 attachments
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.