ssis2008r2 (4/8/2014)
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.