how to change password

We have change administrator password. How can i change the sql server job password, so that the maintain plan work fine as before. Thanks.Modify the login used by the SQL Server Agent service.|||Thank you very much! So i just right click the sql server agent then change password there.|||Right-click the service, open up properties, and go to the Logon tab. That is the most likely culprit.|||i am a little bit confuse. What i did is go to sql server enterprise manager, the expand the management, then right click the sql server agent to open properties. then change the password there. But i am sure what service you got, where can i find it? Did i did something wrong. Can you give me more detail about changing the password? Thank you very much!

How to call just once for multiple report....

Hi all,
I will have to make it possible for one administrator to see one hundred
user's report in just one time.
What I have done is that I just embedded the module which was passing the
parameter to sql reporting server in C# programming code by using looping
statement .
However,if it is the only way, consequently I will have to call sproc as
many as user's count. What it means the performance will be very poor.
I am really curious to hear that. Please could you give me any comment on it?Have another report, fetch for all users and group by user.