when did this war begin and end?
From 149 to 146 BC
Third Punic War
The Third Punic War was the third and last of the Punic Wars fought between Carthage and Rome and lasted from 149 to 146 BC. 
who brought the third punic war to a successful conclusion Scipio Aemilianus
wiki:5389046
Third Punic War [SEP] Introduction
The Third Punic War was the third and last of the Punic Wars fought between Carthage and Rome and lasted from 149 to 146 BC. The war was fought entirely within Carthaginian territory, in modern northern Tunisia. When the Second Punic War ended in 201 BC one of the terms of the peace treaty prohibited Carthage from waging war without Rome's permission. Rome's ally, King Masinissa of Numidia, exploited this to repeatedly raid and seize Carthaginian territory with impunity. In 149 BC Carthage sent an army, under Hasdrubal, against Masinissa, the treaty notwithstanding. The campaign ended in disaster as the Battle of Oroscopa ended with a Carthaginian defeat and the surrender of the Carthaginian army.