Just wanted to know if SQL Server Agent can run in standby mode.
You mean while the computer is powered down? As far as I know, pretty much nothing at all can run.
You might like to take a look here
if you are in the mood for writing some code to wake it up for you.
Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this
If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.
Please surround any code or links you post with the appropriate IFCode formatting tags. It helps readability a lot.