If dbo.DatabaseIntegrityCheck fails, what happens, i.e. how am I notified?
The job will continue. And it will fail (in the end), so it is up to you to get notified when a (this) job fails. For instance send an email on job failure.