Home Forums SQL Server 2005 T-SQL (SS2K5) TRY - CATCH with multiple errors RE: TRY - CATCH with multiple errors
Derrick Smith
SSChampion
Points: 10833
More actions
October 12, 2010 at 2:42 pm
#1235873
In the step of the job on the Advanced tab, specify an output file (.txt). It will log all errors to that.
You should also see more detail in the step of the job history, but that might be truncated. The output file does not get truncated.