It's not a sound effect. When you make reference to music for picture it's called a "Cue." Very, very short cues (like the one in postfacto's YouTube example) are called stingers.
Are you asking about the organ chord cue used in 50's soaps? It's usually a diminished or flat 9th chord.