Hi, Kdd. Welcome.
Very sorry you are going through all this.
As you probably know already, you can't control someone else's behavior. Your SO may not drink while you are there, though it is unfair of him to place you in that "guardian of the gate" situation, but he likely will when you are not.
That is what has happened in past, anyway.
You can't be responsible for his sobriety. It just doesn't work that way.
Take care of yourself. Good luck with the work situation. Hope you find something else soon.