>I need to produce an Excel report or PDF report every night (Schedule SQL Job) and email it to some users.
>How can I do that?

There are a number of ways to do it. The one I like is Blat. It's straightforward to use and doesn't have a lot of Windows dependencies as some other solutions do. You call it with the expected parameters -- from address, to address, message title, message body, some optional stuff -- and it does the rest.