title: Retrieving the an SQL Agent job's specific error
body: <p>I am using <code>msdb..sp_help_job</code> to access whether a job succeeded or failed and can retrieve a general error. </p>
  
  <p>But, I want to access the specific error for the step that failed. I cannot seem to find it. It is not in this list of helpful stored procedures provided by MS
  <a href="http://msdn.microsoft.com/en-us/library/ms187763%28v=SQL.100%29.aspx" rel="nofollow noreferrer">http://msdn.microsoft.com/en-us/library/ms187763%28v=SQL.100%29.aspx</a></p>
  
  <p>The account running the query is limited but does have the SQLUserAgent role and owns the Jobs that it is accessing.</p>