Using a 120VAC coil, you would wire the neutral from the wall to one side of the relay. You would wire the hot to one side of the TIMER and the OUTPUT of the timer to the other side of the relay coil. This means that when the TIMER is on (making contact) the relay coil is energized.
The relay will have 3 sets of contacts Normally Open (NO) and Normaly CLosed (NC). and COMMON.
You would wire the HOT from the timer to one COMMON and the Neutral to the other COMMON. (we want to switch the neutral also, just to be safe). You would wire the pump that you want controlled to the NC (normally closed) contacts. That is, the HOT lead from the pump to the NC contact on the HOT side of the relay and Neutral from the pump to the Neutral side of the relay... Remember this is a double pole relay meaning it is basically 2 independent switches controlled by one coil and we want to switch the hot and neutral just to be safe.
You don't need to hook anything to the NO contacts (unless you want something to come on when the pump is off).
When the coil is idel (the timer is not running), the contacts remain shut and the pump runs as expected. When you set the timer, it energizes the coil and pulls the contacts over to the NO side, breaking the NC connection and turning off the pump.
I hope that makes sense.
Dan