Jim,
I record airglow and background street lights etc. every time I collect data!!!!
Not sure how successful you would be with just a grating in the telescope.
You'd certainly pick up a background, but at a very low resolution.
I use a slit spectroscope on a C11 @f10 and usually 10 min exposure subs with an ATiK 314L camera. Due to the slit the emission for lamps etc appear as definite emission lines. For my work I just remove them using the background removal tool in BASS project.
Walker in his "Spectral Atlas", Section 31 shows a typical "night sky" spectrum.
His example is dominated by Hg, Na and [O I] at 5577A. The airglow at 6300A is missing...
I would think light pollution may be a worse factor than airglow, but I'm no photometric expert.
https://en.wikipedia.org/wiki/Airglow
In Henden & Kaitchuck "Astronomical Photometry, Chapter 9.6, p 229 they discuss airglow and light pollution.
Their conclusions (p231) ""...the light of the night sky is not constant...and therefore will always limit the accuracy of your measurements....
...measurements redward of the V filter are strongly affected by the varying night sky and should be avoided until experience is gained with the UBV system.
...The night sky variations will probably never be noticeable in your photometry, but knowledge of the possibility of these errors should be filed in your mind for later reference.""
Budding & Demican "Introduction to Astronomical Photometry" don't seem to even mention airglow......
Not sure if this helps but if you do need spectra let me know.