The same way when does anything end? When you reach the level that is what you can feasibly resemble as "the end". So in this case, drug-free.
>What target needs to be reached for the war on drugs to stop?
You need to eliminate the negatives that society has to deal with related to illicit drug use? It's not that hard.
When is a newly built house finished?
>Then why has nobody done it?
Huh? Many countries have done it. Why many others haven't is because they don't want to.. Drug usage is a problem for the lower rungs of society, not the government or higher ups. The government must want to improve the life of their citizens at the cost of themselves. Like most objectively good government decisions.