How hot does a gas have to be to achieve its emission spectrum with a glass prism?
What do you mean by "achieve"?
The emission spectrum is always there, at low temperatures it is just very weak. The temperature you need to see it with your experiment will depend on the gas, the experiment, and the lines you want to see.
Separate names with a comma.