The main storyline wasn't closed in the series' final episode but it was resolved in two follow-up movies. Their titles are Stargate: The Ark of Truth and Stargate: Continuum.
[IMDB] [IMDB]