A Metropolitan Police commander has been sacked from the force for a second time after he refused to take a drugs test when accused of smoking cannabis.