Does the engine need to be running when you disconnect the positive battery cable to shut off the check engine light?

No. To erase codes form an OBD-1 vehicle (made before 1996), the engine does not need to be running.

On a side note, NEVER disconnect the battery while the engine is running; it will damage the computer.