Done correctly with the right mortar for the substrate, repointing should last 20 to 30 years or more. Done incorrectly, or with the wrong mortar, it can fail within a few years and cause damage to the surrounding brickwork in the process. The quality of preparation and the mortar specification matter as much as the application itself.