Mail, preferences, general tab, second option from the top "Check for new messages"
With that said, if you use an Exchange or IMAP server, mail is pushed to the computer rather than pulled from the server, so you should leave this to "automatic" in those cases. If you're still using POP3 then that's another story.