How can I disable interval and scheduled jobs before starting Decisions?

Alex

I've made a copy of my production environment on another server for testing purposes, but I haven't started it yet as I don't want the scheduled/interval jobs starting with the environment. How can I turn these off from outside the environment before starting it?

ClaytonM_Decisions

You can use the below queries to disable interval and schedule jobs before you start the environment:

Disable job_schedule

Update job_schedule 

Set active ='0'

Disable interval_schedule_job

Update interval_schedule_job 

Set disabled ='1'

Delete from job_pending

Delete from job_pending

Please note, it is highly recommended that you create a backup of the environment's database before running any queries:

https://documentation.decisions.com/docs/backup-of-decisions-database-and-file-system