your job is a success because you've successfully executed a script which should fail. lol. kiddin.

FYI that SQL server checks your script before you could create the job. 😀 it should also fail during job creation.

you may want to share your script for this. so we could discuss this weird event. 🙂