He was assigned to oversee the Douglas Mclean Memorial Observatory on the planet Hanka that was built to observe a Black hole. He was killed when Nirrti released an Engineered Virus on the population. (SG1: "Singularity")
Behind the scenes
The character was named after Stargate executive producer N. John Smith.