What may give fans of SG-1 hope for more adventures of the team is the following quote from executive producer Robert C. Cooper:
"We've ended that run on SCI FI, and now we're continuing the story with those characters. Our DVD packages sell so well that, if the movies sell as well as the series sells, it's going to be a tremendous success. And MGM will eagerly want more."
So we could potentially be looking at a situation similar to what happened with Star Trek: A successful TV series followed by a number of movies with standalone stories. The difference being that here the movies would go directly to DVD instead of the big screen.
Source: Sci Fi Wire