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.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.