Thanks for the responses.

Phil - I also did manually run the job from server itself using SSMS and it went fine. Will check again tonight.

Koen - Appreciate the tips you...