Thank you both for your replies. I know the job failed because it listed in Enterprise manager with a last run status as failed and the nice red "x" icon.

Another...