that'll only work if you decided to create an output file for this job (which you probably didn't seeing as you're asking this question)...
what you probably want to look at is:
exec sp_help_jobhistory @job_name = '[Job Name]', @step_id = [Step ID]
the column run_status indicates whether the step failed (0 = failed)
don't forget to use msdb and use sp_help_jobstep to get the step id.