The job is made & it runs successfully now, each step of it has some T-Sql queries which run.

But if it fails then the database remains in that state only,...