The only way it can work is if there are descendents alive now carrying the same DNA who have taken a test. Ideally, if they tested every male in Ireland, there would be clusters of people carrying the same Y-DNA as your grandfather. When you pay to have tests done on sites like Family Tree DNA, when your DNA has been processed, you may receive matches with others who have matching DNA who have submitted a test. To my mind, where it becomes important is whether the company you use charges for matches which may occur from samples analysed in the future. Family Tree DNA only charges for the tests, and their fee includes notifying you of matches that could occur in the future. As I understand it, some companies charge a monthly/yearly fee for your DNA profile to remain on their database.