How do I pass or fail a job in SQL Server agent based on a return value from a stored procedure?
Evaluate the result from the proc (with an IF statement) and then if you want it to fail the job execute a THROW command. See this article.