Are you married? Have children? He sounds like a horrible burden.
There’s no unemployment right now so there is zero reason not to work. If one is unable to work, he needs to be on disability. Simply not working or job hoping or keep losing jobs or quitting wouldn’t fly. No good.
As about alcohol, you can’t make him quit. He needs to hit rock bottom. But he never will if you keep saving him.
Honestly I’d start planning to end this. I just don’t see it getting better. Personally for me, person drinking and not working for no apparent reason would be it for me. You deserve better