• I took out the EXEC and inserted a PRINT.

    The SP within the job ran just fine. I then put the exec back and the 1st step for the job run successfully.

    ...my level of T-SQL programing is limited so not sure what exactly happened here....