There are other steps in the Job. The job is failing when it is running the stored procedure which i had mentioned.

I don't see any issues with other steps in the Jobs. when it process the first step it will run the second and third step with out any issues. I am not worried about the other steps.