Many times, it is useful to stop batch jobs already scheduled to run to avoid performance issues on Test or Dev machines. A useful SQL script which can be run on main AOS data DB is as below which will update the batch job status from Waiting to Withhold:
UPDATE BATCHJOB
SET STATUS = 0
WHERE STATUS = 1