Thanks for the guys here and the right guidance, I was able to figure it out.. there is a called "throw" in I believe from 2012 on wards. you just add it in the end of your catch block and it will fail the sql agent job wit the right error.

Many thanks to all.