Paul Randal (6/25/2012)
Be careful though because SQL Agent will only capture the first X bytes of the output (unless that changed in recent versions). You may want to go the route of using the undocumented WITH TABLERESULTS and storing the output in a table for later perusal. See here[/url] for an example.
We write the output to a file and that has the entire output. Use whichever works better for you.