Switch off active batch jobs

When moving an AX database to another instance, example production to test, it is often adviseable to switch off all batch jobs. This can be done using the following SQL script:

-- Reset the batch job status to "Withhold" for "Waiting", "Executing" and "Ready" jobs 
UPDATE [BATCH] SET [STATUS] = 0 WHERE [STATUS] IN (1,2,5)
UPDATE [BATCHJOB] SET [STATUS] = 0 WHERE [STATUS] IN (1,2,5)