I am using SQL agent job with steps. I can see many options and have some queries.
How does failure of a step inside job is determined? Do I need to do a return code?
If I am using capture and masking any errors raised how will it handle failure?