Saudi Arabia has confirmed that Yemen’s Houthi rebels tried to attack its capital with a ballistic missile.