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
Product Language
Version
Category
Operating System
Operating System Language
Steps to Reproduce
Actual Results
Expected Results
Platform
Virtualization