Retrieving the an SQL Agent job's specific error
Posted
by Tom Andrews
on Stack Overflow
See other posts from Stack Overflow
or by Tom Andrews
Published on 2010-03-29T11:02:50Z
Indexed on
2010/03/29
12:03 UTC
Read the original article
Hit count: 445
I am using msdb..sp_help_job to access whether a job succeeded or failed and can retrieve a general error.
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 http://msdn.microsoft.com/en-us/library/ms187763%28v=SQL.100%29.aspx
The account running the query is limited but does have the SQLUserAgent role and owns the Jobs that it is accessing.
© Stack Overflow or respective owner
