Create a job named J. Schedule each call as a seperate Step.

As a default, the error in the Stored Procedure will be returned to the job.

Use the conditions on the job step (success or failrue) to determine the execution path.

The same thing can be done with SSIS.

I guess what is the goal of this process. To be scheduled or to be called on demand?