A senior Metropolitan Police officer has been sacked by the force for a second time after refusing to take a drugs test.