If you are using SQL Server 2008 SP1 or SP2, the release services team yesterday issued cumulative updates for both branches. (And if you are still on SQL Server 2008 RTM, I can only ask, "Why?")
My favorite fix (well, based on wording alone) appears only in the update for SP2:
"FIX: High CPU usage when you run a SQL Server Agent job in SQL Server 2008 or SQL Server 2008 R2 if a column of a dynamic SELECT statement has a value that is many characters long" (KB #2404865)
Note: these updates are not applicable to SQL Server 2008 R2.