Answer
The tournament Scotland was attempting to qualify for when Smith resigned was the UEFA Euro 2008, a quadrennial international men's football championship contested by the senior men's national teams of the members of UEFA. The competition takes place every four years, with the next tournament scheduled to be hosted in Germany in 2024.