When a SQL Agent job fails and logs the error. I see that it logs the error as source SQL Server Agent.
However if the job has executed a stored procedure and the procedure is the one which actually raised the error. Can the error be then logged as Custom ... rather than as SQL Server Agent?
View Complete Post