For SQL 2008, here is what we do:
ALTER DATABASE [XXX] SET AUTO_UPDATE_STATISTICS OFF WITH ROLLBACK IMMEDIATE
ALTER DATABASE [XX] SET AUTO_UPDATE_STATISTICS_ASYNC OFF WITH ROLLBACK IMMEDIATE
select Q.job_id,Q.database_id,Q.in_progress from sys.dm_exec_background_job_queue Q
where Q.in_progress = 1 AND Q.database_id = 9
There is then a function called KILL STATS JOB Y